piggitypow
Registered User.
- Local time
- Today, 14:45
- 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.
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.