Referring to a field on multiple forms in query criteria

[liam]

In my database I have multiple forms which all have a field with the same name. What I want to do is to have a query where the criteria is based on the shared field but from whichever of the forms is open. I have tried:



[Forms]![Form1]![Field] OR [Forms]![Form2]![Field] ... - running the query just gives a prompt for all the forms are not open

I tried searching for an answer and some posts suggested subforms, the problem with this is that I have no idea how to reference the subform in the query criteria when the subform is present on several forms, I have tried using Me.[Subform].form![Field], [Forms]![Parent].[Subform].form.[Field], and other combinations of . and ! (not entirely sure which I should use) but neither of these work.

Is there a way to reference a subform in a query criteria without specifying the exact form it is present on because I really don't want to make lots of different queries that are almost identical?

Any guidance on this would be greatly appreciated!

[ranman256]

The query will only work on 1 form.
if you have 2 forms ,then you need 2 queries.

if you want to reference a sub form, use the BUILDER, to pick the object.
it will always get it right.

[liam]

The query will only work on 1 form.
if you have 2 forms ,then you need 2 queries.

if you want to reference a sub form, use the BUILDER, to pick the object.
it will always get it right.

I can use the builder to get the criteria to reference the subform but only for a specific form. The subform I want to reference is used on several forms and I want to reference the subform independent of whichever parent form is open with a single criteria, is that not possible?