Toggle Filter On and Off

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.
 
Top