Filters

Using Find is OK if you just want to see records that meet certain criteria on the screen. Filters are used to retrieve a subset of records from a table and allow you to temporarily view or edit a subset of records while you're in a form or datasheet.

For example, if you want to print out a subset of records that match particular criteria, you need to see all the matching records on the screen together. To do this, you can use the Filter by Selection option.