how to display subform records on report

[BJF]

Hi,

How do I pull information from a subform (more than 1 record in subform at times) to put on my report?

I have added the subform to the report and set Visible property to No,

I know the syntax to refer to the subform and its fields but I don't understand how to get all records in the subform for the main record to be displayed

Brian

 

[Mihail]

Is not necessary to put the subform in the report.
How you intend to use the subform's data ? As a subreport or as a report ?

 

[BJF]

Hi Mihail , thanks for response,

I need to use it as a subreport i suppose:
I'm not formally trained in access, but what i have is a report that I print as a Packing list; the packing list source is taken from tblSalesOrders which draws the main order info, and then a linked subform or subtable to that record holds specific info about the order. Sometimes the subform or subtable contains one record, sometimes more, and i want to list information from that subtable on the packing list(report), but i'm not sure how to draw that information out onto the report. I hope this makes some sence, like i say I know my way around access fairly well but not formally. Please help!!
Thanks for your patience
BJF

 

[Mihail]

My patience is not a problem, but the design of your DB can be because, usually, a table store more and more records.
From your description, either this table is a temporary table either (more plausible) you have a query, not a table.

If you can, Save As.... 2003 format and upload your DB.
I use Access 2007 so, if your DB is also in this format you can upload it without conversion.

Have you tried to base the report directly on your table (or query) ?