Apply an existing query as a filter on a form or datasheet

While you can save only one filter for each datasheet, subdatasheet, form, or subform, you can use queries that you've already created as additional filters. A query must meet certain requirements if you're going to use it as a filter. For more information on those requirements, click .

1. Click in the datasheet, subdatasheet, form, or subform you want to filter.
   
   
2. Switch to the Filter By Form window or the Advanced Filter/Sort window.

   How?

3. On the toolbar, click Load From Query .
   
   
4. In the Filter box, select a query, and then click OK.
   
   
5. Click Apply Filter on the toolbar.

Note   For information on creating a form or report based on the filtered data, click .