Save filters as queries so they can be reused (97/2000/2002)

Filters provide a quick way to limit the data displayed in a datasheet or form. The Filter By Form feature makes creating a filter especially easy since you can set your criteria using actual data values supplied by dropdown lists. Whether you use the Filter By Form or Advanced Filter, chances are you'll create a filter that you want to use again at a later time. Fortunately, you can save the filter as a regular Access query. You can then open the query like any other through the Database window. You can also load a saved query as a filter for another database object.

To save a filter, choose Records | Filter from the menu bar and then Filter By Form or Advanced Filter/Sort. Configure your filter as needed, then choose File | Save As Query from the menu bar (or click the Save As Query toolbar button). Finally, specify a name for the query as you typically would.

To re-use a stored query as a filter for a database object, open the object and again activate either the Filter By Form or Advanced Filter feature. Then, choose File | Load From Query from the menu bar or click the Load From Query button. Any relevant queries are listed in the Applicable Filter dialog box. Simply select the appropriate query, click OK, and choose Filter | Apply Filter/Sort from the menu bar.

<<<Back Home Next>>>