Switch between filter windows in a table, query, or form

Switch between filter windows in a table, query, or form

You can switch between windows to create or modify a filter by using the method that works best for your filtering needs, or to see a different view of an existing filter. Filter By Form and Advanced Filter/Sort have their own windows. However, you use Filter By Selection or Filter For Input directly in Form view or Datasheet view.

To switch to From this window Do this
Filter By Form Datasheet view or Form view On the toolbar, click Filter By Form .
  Advanced Filter/Sort On the Filter menu, click Filter By Form.
Advanced
Filter/Sort
Datasheet view or Form view On the Records menu, point to Filter, and then click Advanced Filter/Sort.
  Filter By Form On the Filter menu, click Advanced Filter/Sort.

To apply a filter from either Filter By Form or the Advanced Filter/Sort window and see the results in Datasheet view or Form view, click Apply Filter on the toolbar. To close either filter window and return to Datasheet view or Form view without applying the filter, click Close on the toolbar.

Note   After specifying the values you're searching for by using Filter By Selection, Filter By Form, or Filter For Input, you can switch to the Advanced Filter/Sort window to see how the values you specified are translated into a criteria expression in the design grid.