Filter How-Tos

The following topics describe how to build and apply a filter to limit the records shown by a table:

• Creating a Filter Using the Filter Wizard

• Specifying Selection Criteria in the Filter Wizard

• Specifying Sort Criteria in the Filter Wizard

• Saving and/or Applying a Filter from the Filter Wizard

• Applying a Saved Filter to Limit or Order Records

• Supplying Parameter Values at Run Time

• Responding to the No Matches Window

• Determining if a Filter Has Been Applied to a Table

• Removing an Applied Filter

• Using a ‘Select’ Command to Select or Find a Record

When a filter is applied to a table or form, it is applied in conjunction with the Filter by commands selected on the Filter menu. This means that if Filter by commands are selected, the filter is applied only to those records that meet the Filter by criteria. For more information, see ‘Filter by’ Commands.