Query with multiple parameters

[Knaabis]

I need to run the query with the form, where the query criteria are the values ​​of subforms.
For example - [Forms]! [Cutting_List]! [Cutting_List_Details subform]! [Order_No]
The query works, but only the first entry (criteria) in subform ...
How to "get" request for use of all relevant records in the subform?


For example - [Forms]! [Cutting_List]! [Cutting_List_Details subform]! [Order_No]=10, 15, 25

[NTC]

well first let's correct the syntax:
[Forms]![Cutting_List].[Cutting_List_Details subform].Form![Order_No]

but if I understand your post correctly, and I'm not sure I do, but - you have a subform that is in continuous form mode so you have multiple records - in which case calling the value as proposed above is not going to work regardless of the syntax...

so what you need to do is approach it differently; that subform is a record set - - you need to establish that same record set - -so write a new query that returns the exact same records as your subform. Then use this query record set joined into a new query that has your data.... at this point I can't give you an exact guide as I don't know whether you are needed to do calculations or what....but this is the general idea.

Hope it helps.

[Knaabis]

Forms>subform records is the criterion for Query.
If in subform is only one entry, then Query looks good, but if in Subform are many entries, then Query returns result only by first subform entry.
I need to Query be run from Form and use the subform records for Query filter.