How do you remove a filter to reapply it to new criteria

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

Guest

I have a form that is used to filter by selection from a drop down list based
on the choice made, all records in the database are filtered based on this
selection. You realize you made the wrong choice and pull the list down
again to select the correct choice. This again filters all the records in
the database based on the new selection. Is this possible and how do you make
it happen? I am new to Access so please any help even very basic would be of
help.

Thank You
 
The Filter By Selection button adds the new filter to the existing one. You
therefore need to click the Remove Filter button on the toolbar before
making another Filter By Selection.

You cannot modify the behavior of the this toolbar button. You could program
your own though, if you are comfortable with writing VBA code. Useful
concepts would be:
- Screen.ActiveControl;
- Filter and FilterOn properties of form;
- BuildCriteria().
 
Back
Top