Modify a filter by using Filter By Selection or Filter Excluding Selection

Modify a filter by using Filter By Selection or Filter Excluding Selection

You can modify the filter by adding more criteria or changing the existing criteria.

  1. To further limit a set of records that already has a filter applied, start with step 2. To change the criteria previously defined for a filter, first remove the filter if it is currently applied.

    How?

  2. In Form or Datasheet view, select a value in the form, subform, datasheet, or subdatasheet that you want to use as criteria, and then click either Filter By Selection on the toolbar or right-click the value and click Filter Excluding Selection on the shortcut menu. Repeat this process until you have the records you want.

Note   You can also switch to the Filter By Form window or Advanced Filter/Sort window to change the criteria, including specifying alternative criteria (one criteria or another).