How to clear filter when I close out tables?

[wuzhuo77]

Hello everyone,

I have created a switchboard for my dataset. Once I click on the button, I could enter the parameter value to filter on the ID I need.
Ex. Enter ID number: 12345


Once I get in there, I should have all records with ID 12345. I want to filter these data further, I might do ID2=123456
Now, I have all the records whose ID is 12345 and ID2 is 123456.
I closed this table and reopen it again, I still need to enter ID number 12345 but it automatically also filter on 123456. I have to clear the second filter every time. I'm wondering if there is anyway to prevent it from showing the previous history search? Please help me! Thank you!

[nick404]

Check in properties table under Data tab if the Filter on Load is set to yes for that filter.

[wuzhuo77]

Yep, the filter on load in form is set to "yes". I have multiple columns such as id id2 address, etc. Each column under property sheet doesn't have a "filter on load" option.

[nick404]

The form as a whole will have the Filter on Load property. On form's prop sheet check to see if the Filter is set to filter the id2, and if filter on load is set to yes then set it to no or delete the filter.

[wuzhuo77]

The filter under form is set to "Enter ID number" (first ID) and the Filter on Load is set to yes. I still want to keep the filter because I would like to filter by the first ID but it's a matter of how to clear the second or later filters when I close it out. If I set Filter on Load to no, it will remove all my filters. I still want to have the parameter value entered every time to restrict on certain ID only.

[June7]

You have a form that is based on table with a dynamic filter parameter? I have never done this. I don't use tables or queries with dynamic filter parameters. I apply all filter criteria to report when it is opened and/or its Filter property after opened.