I have a form that lists records and i have the capability to apply a filter there. I also have a button that links to a report where i can get the selected records (by the filter) print. In the apply filtert event of the form i have the following code:
Me.Filter = Empty
ifiltertype = ApplyType
I also have a module with the following code:
DoCmd.SelectObject acForm, "frm_hdw_rlist", True
Dim ifiltertype As Integer
ifiltertype = ""
The filter works fine with the report. The only problem that i have is that when i close the form and open it again the filter value holds its last value and so in the report i get the last filtered values even if i have not choosen a new filter. If a choose a new filter then the value changes.
What i need help is how to clean the value of the filter every time the form or the report closes.