Add an existing report to another existing report to create a subreport

If the subreport will be linked to the main report, make sure you've set up the table relationships correctly before using this procedure. For more information, click .

1. Open the report you want to use as the main report in Design view.
   
   
2. Make sure the Control Wizards tool in the toolbox is pressed in.
   
   
3. Press F11 to switch to the Database window.
   
   
4. Drag a report or datasheet from the Database window to the section you want the subreport to appear in on the main report.

Microsoft Access adds a subreport control to the report.

Notes

• For information on referring to the value of a control on a subreport, click .
  
  
• For information on troubleshooting subreports, click .