Modify a filter (ADP)

Microsoft Office Access 2003

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.
  2. In Form view or Datasheet view, select a value in the form, subform, datasheet, or subdatasheet that you want to use as criteria, and then either click Filter By Selection Button image 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.

ShowModify 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.
  2. In Form view 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, or 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.

ShowModify a filter by using Filter By Form or Server Filter By Form

You can modify the filter by adding to blank fields other values you want the filtered records to contain, deleting or changing values in a field, or making any of the following modifications.

ShowClear all the fields

  • Click Clear Grid Button image on the toolbar.

ShowDelete an Or tab

  1. Click the Or tab you want to delete.
  2. On the Edit menu, click Delete Tab.