Print duplicate copies of subreport within report

[bu2ouin4]

I have a subreport that results in basically a "form" to be completed after printing. It is not data-dependent. The subreport contains several formatted text boxes--rows where our guests check off age information of family members for us.

The subreport is nested among other subreports that simply show rows of data. I need to duplicate this subreport multiple times, but the number of times will vary.

How can I print duplicate copies of this one subreport?

 

[dhookom]

If I understand correctly, you can add a record source to your subreport that returns exactly "multiple times". You aren't suggested how many times or if all the "times" are consecutive in the report or are they in multiple places in the main report.

Duane
Hook'D on Access
MS Access MVP

 

[bu2ouin4]

Yes, I will have a record source to state how many times I want to show the subreport. I want the subreport to repeat consecutively in one place in the main report.

 

[dhookom]

Check out Allen Browne's Print a Quantity of a Label

Duane
Hook'D on Access
MS Access MVP

 

[bu2ouin4]

It's taken me a few interrupted days to figure out the details of this approach, but I finally got it. I'm now working out my formatting and needed parameters for it to print like I need. Thank you so much!

 

[bu2ouin4]

I thought I had this worked out... I am attempting to prompt the user to enter the quantity of "labels" when my main report runs. My query on the CountID table and my table of records works great when it stands alone. The subreport with "label" data even works great alone. It prompts me ONCE for the quantity then spits out that many copies of the "label" in succession.

But when I put this subreport in my main report it prompts me multiple times to tell it the quantity. Any suggestions?

 

[MajP]

I am not sure of how you did it, but you may be

 

[dhookom]

IMO, parameter prompts are never acceptable user interface faq701-6763. I always use controls on forms for this type of requirement.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Sorry about my previous cryptic message, I inadvertently hit the submit button.

 

[bu2ouin4]

Got it!!! Everything is working beautifully now. Thanks for pointing me in better directions.