I have syntax similar to the following as criteria for one of my query fields:
I want to use this query on multiple forms, so can I make this syntax dynamic? Instead of [Forms]![myForm], can I insert a variable that will automatically insert the form name? For example: [Me.Form]![formControl].Code:[Forms]![myForm]![myControl]