Clearing criteria in filters

[iazcac]

Hi

I have a filter button on my toolbar to search for records.

When i press this button, it lets me enter my criteria.
However, it contains the previously entered criteria from the last search(es)
I also have another button to clear the grid of these criteria on the toolbar

Is it possible to combine these two and create a new toolbar button which first clears all the previous criteria before allowing me to enter new criteria into a blank form?

Chris

 

[nyoman]

Add this code to your button

To apply filter : DoCmd.ApplyFilter , "Your Criteria"

To show all records : DoCmd.ShowAllRecords

 

[maxmangion]

to clear your previously inputter criteria simply put

Me.YourFieldname = null