Report with additional subforms

[rlangford]

Hi all, I need to create a report with multiple subforms and I cannot figure out how to do this. I set up my first report and then I believe I need to add "more detail" sections or another page to this report so i can drag in my additional forms.

How do i separate out sub forms? Ideally I will want to have the main table on the top then the sub form in the middle, then the next on the bottom of the page.

As always thanks!

 

[EternalMyrtle]

These are called subreports. There is a tool in the reports design tab (Controls section) that is almost exactly the same as the one in the forms design tab.

See image. Just click it and make your subreport setting the record source as you would for a subform.

Just a warning, in my experience with Access 2007 reports with subforms are extremely slow to load especially if it is a long report. So slow in fact that I have resorted to creating large and complex queries instead to get around using them.