Resetting parameter filter (A2K)

Topic

New Reply

I have a button that applies a parameter query (filter) with DoCmd.ApplyFilter “q2GetOneIncidentIDRecord” . Another button, with “Me.FilterOn = False” turns the filter off.

When I press the filter button I am prompted for an Incident ID. The query (filter) does work. Pressing the second button does remove the filter. However, pressing the first button does not invoke the parameter pop up again, but rather just shows the originally filtered record.

What is the proper way to apply, remove, and then reapply a filter with a parameter?

Thanks,

Randy

Reply | Quote

Replies

In my post, above, I said “Another button, with “Me.FilterOn = False” turns the filter off.” I changed that to “DoCmd.ShowAllRecords” with the same result. Then I changed it to:
DoCmd.ShowAllRecords
DoCmd.ShowAllRecords
… and it works fine. That still doesn’t answer my question. And why should I have to enter this command twice to make it work?

Thanks

Reply | Quote

Me.Filter = “”

Reply | Quote