Jim-
The more efficient way to do it is:
Me.Filter = "[Crew 1] = 0"
Me.FilterOn = True
To remove the filter, just do:
Me.FilterOn = False
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 15, 2014, at 7:22 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have 3 buttons that filters a form based on 3 different criteria. I am using syntax as follows
DoCmd.ApplyFilter , "[Crew 1] = 0"
The users are technically challenged and will not see the Toggle filter button on the ribbon. How would I code an applyfilter button to toggle the filter off?
Thank You
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar