Filter By Form

A technique for filtering data that uses a version of the current form or datasheet with empty fields in which you can type the values you want the filtered records to contain. In a Microsoft Access project, you can filter data at the server before it’s retrieved from the database by using Server Filter By Form.