OpenForm (filter name)

[JPFred]

I am fairly new to the macro creation utility in access and was wondering if anyone can give me a few examples with the use of "filter name". From what I can tell you can place a form or query name here to restrict record retrieval.

Thanks,

Doc

 

[Ranman256]

less of a restriction, more of just a filter. Users can unfilter.
If you want to restrict, base the form on a query to the exact criteria, rather than filtering a query.

 

[A S MANN]

Use the following as filter in condition part of query
=[Forms]![Form Name].[Filter Field name]
This will filter query to Form Name and shown Filter Field name.