Modify a filter by using Filter For Input

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, do one of the following:
   • Right-click the field you want to specify criteria for in the main form, datasheet, subform, or subdatasheet, and then in the Filter For box on the shortcut menu, type the value you want to use as criteria.
     
     
   • Right-click any field in the main form, datasheet, subform, subdatasheet, and specify the expression you want to use as criteria in the Filter For box.
3. Press TAB and repeat step 2 until you have the records you want.

   For more information about using Filter For Input, click .

Note   You can also switch to the Filter By Form window or Advanced Filter/Sort window to change the criteria.