Using Access 2010
Here is the code.
Me.Form.Filter = ""
Me.FilterOn = True
I would expect the value of me.Form.Filter to be = "".
I would expect for the filter would allow everything even though the filter is still on.
Instead, the value of Me.Form.Filter seems unaffected by this code. The old filter condition remains.