Toggle Filter On and Off

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

Kirk P.

I've got this code in a command button on a form that applies a filter to a
check box control

Me.Filter = "DUPLICATE = -1"
Me.FilterOn = True

Filter works just fine when you click the button - is there a way to remove
the filter (to show all records) when you click the button again? Basically
want ability to toggle between "all records" and only those where chkDups is
checked.
 
Back
Top