FilterByForm Problem

Sep 12, 2006

Hi,

On a form I have a button that allows me to FilterByForm. Although it works fine I don't have any checking in place, so when a field is filtered and a certain value is selected where there are no records in the table that match it currently just shows the same form but with all fields and names removed.

Can anyone help with a bit of code thay would say throw up a msgbox box if the result of the filter is 0 results?

Many Thanks,

View Replies

FilterByForm - Reporting Problem

Jul 31, 2006

Hi,

I have read through a few posts but none seem to resolve the issue I am experiencing.

I have a form with a FilterByForm button. This works fine. I also have a button that is supposed to display the results of the filter on a report. Everytime I click this button it prompts me to enter a parameter value.

Here is the code I am using for the button:

DoCmd.OpenReport "Temp", acViewPreview, , Me.Filter

Any help appriciated.

View 5 Replies View Related