Remove Filter using code or macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
-----Original Message-----
Hi,
I would like to remove filter in a form so I can then
Click to expand...
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
Click to expand...
Hi Sam,

DoCmd.ShowAllRecords

Luck
Jonathan
 
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
Click to expand...
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?
 
Back
Top