OpenForm (filter name) (1 Viewer)

JPFred

Registered User.
Local time
Today, 18:57
Joined
Oct 29, 2017
Messages
47
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

Well-known member
Local time
Today, 18:57
Joined
Apr 9, 2015
Messages
4,339
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

New member
Local time
Tomorrow, 04:27
Joined
Oct 18, 2017
Messages
9
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.
 

Users who are viewing this thread

Top Bottom