filter 1

[herd]

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

 

[mp9]

If your button is called cmdFilter, and the field to which your checkbox is bound is a boolean called CheckIt (untested):

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