Subform Information for Report

[BJF]

Hello,

I don't understand how to get information from more than 1 record in my subform onto my report.

I am using a report format to print out a packing list.
The report draws information from a form and a subform.

If the subform has 1 record only, then I get the information i need.
How do i specify different records when getting the information.

example:
I use this as the control source for a field on my report.

=[Reports]![rptPackingList]![fsubProdOrderDetails]![numberofrolls]


-and it gives me the number of rolls from record 1 in that subform.

Sometimes my subform has 5 records; how would I specify from which record I'd like the number of rolls from?

Any help please!
-Brian

 

[JHB]

Could you explain in another way, what you're wanting - a printscreen?

 

[AccessBlaster]

You would need to use the primary key for that subform. Whether you print one record or twenty, you have to identify the record with a primary key.

Google printing records using subforms.

 

[BJF]

Thanks for the response AccessBlaster but I figured out that in order to get what I needed I just had to create another report with the information that I wanted and then add that report as a subreport to my main report design.