Retaining Filter in Form

[Roaming_Tigerr]

Access 2007

Hello everyone - hope someone can help. I am fairly new to Access and am having a problem retaining filter settings.

Scenario: I have a table with 800 records viewed by Form. Several of these records are filtered by one basic criteria. The filter works manually without problem but when the Form is closed the filter is lost and I want to retain it so that when the Form is re-opened the filter is automatically invoked. Is there a simple way to do this? I've been going round & round in circles:banghead: so hopefully one of you geniuses with have the answer I need?

Many thanks in anticipation.

Mike

 

[Pat Hartman]

Re: Retainin Filter in Form

Anything that you want to persist after the form/database is closed must be stored in a table. Some form settings can be changed at runtime and Access will remember them but apparently filters don't fall into that category.

When you make the table to store the filter you will need to include something to identify the form and something to identify the user if you want each user to be able to have his own preferred filter. The table should be in the BE because otherwise it will be lost if you replace the FE with a new version and that is why the userID is required in the settings table.