Filter By Selection

A technique for filtering data that's based on data you select in a form, datasheet, or data access page. In a form or datasheet, you can filter for all or part of a value you select. For example, you can select the first character in a field to find all records that start with that character in the filtered field. In a data access page, you can only filter for the entire value in the field.