Toggle Filter On and Off

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

 

[Klatuu]

Me.Filter = "DUPLICATE = -1"
Me.FilterOn = Not Me.FilterON

 

[Kirk P.]

Perfect - thank you!

Me.Filter = "DUPLICATE = -1"
Me.FilterOn = Not Me.FilterON