Toggle Filter Access 2007

[geospatial]

Looking for a way to place a command button on my form that will basically click the toggle filter button to activate.deactivate it. My form currently has a button that will run filter by form, but instead of having a user go to the ribbon to click toggle filter I want to make another button that will work the same way.

Thanks in advance.

 

[xenou]

Not sure but I'd think any standard button can be used,

If Me.FilterOn = True then
    Me.FilterOn = False
Else
    Me.FilterOn = True
End If

OR:

Me.FilterOn = Not Me.FilterOn

Untested.

ξ

 

[geospatial]

Crap when I enable filter by form all buttons are greyed out.