Form filter button on form

[dkape]

Is it possible to put the apply for filter button ( the hour glass button, which is on the menu bar) on a form?

 

[KyleS]

Yes,

To replicate that button's functionality you just need to create a macro with "ApplyFilter" as the command line. Or if you're comfortable at all with VBA then just use this code on the "OnClick" of your button:

Private Sub ButtonNameHere_Click()
DoCmd.ApplyFilter "[FieldName] = 'x'"
End Sub

If you give me some more details as to how you want to filter, I can be more specific...

Hope this helps, Kyle

 

[dkape]

Thanks, for the reply. What I actually want to do is give the user a way to un-apply a filter, and show all records.

 

[KyleS]

OK, well that's just as easy, just chage the code to this:

Private Sub ButtonNameHere_Click()
Me.FilterOn = False
End Sub Kyle