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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filter 1

Status
Not open for further replies.
herd

herd

Technical User
Jun 23, 2003
46
0
0
US
How can I used a command button in a form to filter all records in which a check box is checked on that record.


Thanks Gary
 
Sort by date Sort by votes
If your button is called cmdFilter, and the field to which your checkbox is bound is a boolean called CheckIt (untested):
Code: 
Private Sub cmdFilter_Click()
On Error GoTo Err_cmdFilter_Click

    DoCmd.ApplyFilter , "CheckIt = -1"
    
Exit_cmdFilter_Click:
    Exit Sub

Err_cmdFilter_Click:
    MsgBox Err.Number & ": " & Err.Description, vbExclamation
    Resume Exit_cmdFilter_Click
    
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Filter vba problem
Replies
0
Views
85
Moss100
Moss100
Moss100
  • Locked
  • Question
Vba filter not working 3
Replies
7
Views
121
Cole Mendoza
Cole Mendoza
Moss100
  • Locked
  • Question
VBA Filter problem
Replies
3
Views
64
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Filter with multiple criteria 1
Replies
3
Views
42
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Problem with filter string 2
Replies
13
Views
96
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top