Button to Filter

[ntolani]

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]

Try this on the buttons:

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

Matt