Filter on form

N

Neil Greenough

I have set up a filter for a form so that it filters certain contacts in a
department. Nonetheless, when I close the form and reopne it, the filter is
cancelled.

Is there a way I can set it up so that the filter is a permanant feature and
not just a temporary one?
 
D

Douglas J. Steele

If you want it permanently, why not create a query that has the appropriate
WHERE clause, and use that query as the RecordSource for the form?
 
Top