Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Apply a filter to a form onopen

Status
Not open for further replies.
MrMode

MrMode

Technical User
Aug 28, 2003
195
GB
I am trying to apply a filter to a form onopen but struggling.

I have a yes/no field and I want the form to open and only show those records where the field is empty (0).

Can anyone help?
 
Sort by date Sort by votes
What code have you tried so far? i.e.

DoCmd.ApplyFilter [fieldname] = False

There's a good example in the Litwin, Getz Access Desktop programming book.
 
Upvote 0 Downvote
I have tried the following:

DoCmd.ApplyFilter , client.clientwin = False
DoCmd.ApplyFilter , client.clientwin = 0
DoCmd.ApplyFilter , client.clientwin like 0

?!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
154
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
175
renigar
renigar
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
266
BJZeak
BJZeak
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
375
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
251
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top