unselecting the "filter" toolbar button

[Brad Pears]

We have a form on which the user can "Find" customers by first/last name and
phone number.

When the users enters their criteria and clicks "Find", the following code
runs...

' Apply the filter
DoCmd.ApplyFilter "qryFindCustomer"

The query "qryFindCustomer" uses the "like" for each of the criteria fields
to return the appropriate records.

If there are no records returned, I notify the user of this but the one
thing I can't seem to do in code is to "uncheck" that filter button (which
is depressed because I have a filter set) so all records show up again after
I have notified them that "no records exist for the entered criteria"...

What command can I run to basically reset that filter and thereby "uncheck"
the filter toolbar button?

Thanks,

Brad

 

[Graham Mandeno]

Hi Brad

Try:
Me.FilterOn = False