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 - 13 Apr 2005 23:46 GMT
Hi Brad
Try:
Me.FilterOn = False

Signature
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
> We have a form on which the user can "Find" customers by first/last name
> and phone number.
[quoted text clipped - 20 lines]
>
> Brad