need generalized in-form query that works for any form

piggitypow

Registered User.
Local time
Today, 03:24
Joined
Mar 19, 2005
Messages
19
I have a search form that includes the following expression for the criteria component of query design:

Like "*" & [Forms]![frmDocumentsUpdate]![Search2] & "*"

In the form frmDocumentsUpdate this works fine, but I want to apply this single query to several other forms without designing a different version for each form. How do I alter the [frmDocumentsUpdate] portion of the query criteria so that it will work in any form? I assume this involves the "me" command but I don't know the proper syntax.
 

Users who are viewing this thread

Back
Top Bottom