Reset Filter On Close

[Power]

Hello, I'm fairly new to Access and VBA so forgive my ignorance. My coding is less than efficient but most of the time things work. I have a form that opens with basic information: UserName, Location, AssetNum, phonenum....I found that if I right click in the AssetNum field and select Number Filters>Equals and enter a number, the form filters for just that record. However, I want to clear the filter using the On Close event but not sure how. I have tried several approaches and get an syntax error each time I close the form. Can someone tell me if there is a simple line of code to do this? Such as Me.filter = "AssetNum = & """. Do I reference the form or the controls property?

BTW, I searched the forum for Clear Filter, Reset Filter and others but nothing seemed to work.



Thank you in advance.

[Bob Fitz]

Hi

To remove the filter from a form you could try using:
Me.Filter = ""
Me.FilterOn = False