Trouble with filter

[itprog]

I have a form that opens with a filter for active records based on a date field value of null.

On my form I have a button to show active records with a date field value of null and a button to show all records regardless of date value. These buttons work fine.

I have another button that pops up a form to filter by location input by user. The filter by location is to work on the active records only. The filter by location works the first time I run it. Then I click on the active records button to show all active records. I run the filter by location again, but now it shows the location that I put in the first time. It does not filter by my new location selection.

I am using a macro to apply the filter for location. I have tried adding the command in the macro to removefiltersort, but that does not clear out the value either. The only to clear the value is if I exit the form, then reopen.

Does anyone have any idea why it is retaining the original value and how I can change it? I searched threads, but nothing seems to fit the problem I'm having.

Thanks

 

[aleb]

Can you post your db?

 

[itprog]

The db contains information I cannot post. Is there any other info I can give you?

 

[aleb]

Create blank db. Then open this db, go to file>get external data >import.
Point to your old db. Select all in tables, queries, forms, macros and modules. Click options and select definition only . This will copy only the structure of your dbase.