View Full Version : Button to Filter


ntolani
05-23-2001, 12:15 PM
I was just wondering how to create buttons on a form that will clear the form (Filter by Form) and to perform the "search" (Apply Filter). The Wizard doesn't seem to be helping me with these buttons, so I think I need to write some vb code. Thanks!

Matthew Snook
05-23-2001, 03:24 PM
Try this on the buttons:

Private Sub FilterOnButton_Click()
Me.FilterOn = True
End Sub
Private Sub FilterOffButton_Click()
Me.FilterOn = False
End Sub

Matt