Toggle a filter

[Rusty]

Hello,

I am trying to get a Command button to toggle the filter "on" and "off" on a form. I have done this by using:

DoCmd.RunCommand acCmdToggleFilter

How do I get this button to enable only if filter is on? I have tried several different things in the On Current event of the form, but to no avail, e.g.

Private Sub Form_Current()
If ????? Then
cmdFilter.Enabled = False
Else
cmdFilter.Enabled = True
End If

End Sub

Can anyone help?

Rusty

 

[ghudson]

Try...

If Me.FilterOn = True Then
    cmdFilter.Enabled = True
Else
    cmdFilter.Enabled = False
End If