Gents I've looked at some of the archived threads but am having the following difficulty.
I have a HUGE Excel file link.
Query1 pulls the info and is the source for the report "LOT / LOB Breakdown".
The report genereates without issue on the entire query.
I have a form with 2 subforms. The subforms are populated by the user selected multiple records.
"Subform" has the individual listings of the records, which may have duplicate "Field3" entries.
"Subform2" has the calculated values grouped by "Field3" and lists this field distinctly.
What I need to do is filter the query (Query1) out to the report "LOT / LOB Breakdown" including those Field3 identifiers shown in subform (or subform2).
My problem has been not getting them all to populate - I've tried the DAO.Recordset / Do While -- Loop method and am having difficulty.
Help would be greatly appreciated.
I have a HUGE Excel file link.
Query1 pulls the info and is the source for the report "LOT / LOB Breakdown".
The report genereates without issue on the entire query.
I have a form with 2 subforms. The subforms are populated by the user selected multiple records.
"Subform" has the individual listings of the records, which may have duplicate "Field3" entries.
"Subform2" has the calculated values grouped by "Field3" and lists this field distinctly.
What I need to do is filter the query (Query1) out to the report "LOT / LOB Breakdown" including those Field3 identifiers shown in subform (or subform2).
My problem has been not getting them all to populate - I've tried the DAO.Recordset / Do While -- Loop method and am having difficulty.
Help would be greatly appreciated.
