Issues Printing multiple files from a a single form

[ericbrener]

I've got a macro set up, which pulls up 10 reports at once. All of
these reports are derived from the same data set and use a common form.
The input from this form restricts the data set, and populates a date
label.

So - - - for each report, the form pop-ups, i am asked to fill in the
appropriate date ranges, and report is generated. The data is correct
and the label is correct. Great.

My problem is once i try to print these reports. The first report that
I print turns out alright. All subsequent reports have the correct
data sets, but the labels all appear as "#Error" or "#N/A"

Any suggestions?

 

[Marshall Barton]

I've got a macro set up, which pulls up 10 reports at once. All of
these reports are derived from the same data set and use a common form.
The input from this form restricts the data set, and populates a date
label.

So - - - for each report, the form pop-ups, i am asked to fill in the
appropriate date ranges, and report is generated. The data is correct
and the label is correct. Great.

My problem is once i try to print these reports. The first report that
I print turns out alright. All subsequent reports have the correct
data sets, but the labels all appear as "#Error" or "#N/A"

I kind of sounds like the form is being closed before the
last report completes. Maybe by the first report??