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 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?

Thanks

 

[ITProg]

I made a typo in the 3rd paragraph: the filter by location when run again, "does not" filter by my new location selection.