Remove Filter using code or macro

[Sam Kuo]

Hi,
I would like to remove filter in a form so I can then carry out the next action with a combo box. Is there an alternative other than clicking the "Remove Filter" icon on toolbar? Perhaps a code in the combo box property that does it?

Any help is much apreciated!
Sam

 

[Jonathan Parminter]

-----Original Message-----
Hi,
I would like to remove filter in a form so I can then

carry out the next action with a combo box. Is there an
alternative other than clicking the "Remove Filter" icon
on toolbar? Perhaps a code in the combo box property that
does it?

Any help is much apreciated!
Sam

Hi Sam,

DoCmd.ShowAllRecords

Luck
Jonathan

 

[Seth Schwarm]

I have used the method mentioned by Jonathon and also a
second method which is much more explicit. I would
advise you to consider it even for applying filters and
not just removing them

Remove a filter:

Me.FilterOn = False (Me refers to the form the code is a
part of)

Apply a filter:

Me.Filter = your filter criteria
Me.FilterOn = True

Happy coding,

Seth Schwarm

-----Original Message-----
Hi,
I would like to remove filter in a form so I can then

carry out the next action with a combo box. Is there an
alternative other than clicking the "Remove Filter" icon
on toolbar? Perhaps a code in the combo box property that
does it?

 

[Sam Kuo]

Thanks alot, Jonathan and Seth.
Me.FilterOn works just fine