Print multiple reports from a subform using a single click on the main form

  • Thread starter Thread starter Nathan Guill
  • Start date Start date
N

Nathan Guill

I have a form that has one field on it (ToolIdx) and a subform based on that
field. What I want to do is to print all the reports that are based off of
that subform from a control on the mainform. So I need to step through the
records in this subform (preferrably invisible to the user) to print this
report. There is a control on the subform to print as well, but this is to
print the individual report and this works fine. I just need to know how I
can step through these records. Any help will be appreciated.
 
Nathan,
Since all the subform records are related to the ToolIdx on the main
form, then use that value to filter the report, so that all/only the records
in your table that have that ToolIdx are reported upon.
If your report yields one page per subform record with that Idx, and you
have 6 subform records that meet that criteria, then the report should print
six pages automatically.
In the query for your report, use the value of ToolIdx from the open form
to establish a criteria for the ToolIdx field in the query...
= Forms!frmYourToolIdxForm!ToolIdx
hth
Al Camp
 
I figured out how to do it using one of the switchboard routines as an
example of creating a ADO recordset.
 
Back
Top