Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2005

Tip: Looking for answers? Try searching our database.

unselecting the "filter" toolbar button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brad Pears - 13 Apr 2005 19:24 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.