I am trying to get a Command button to toggle the filter "on" and "off" on a form. I have done this by using:
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
cmdFilter.Enabled = True