Create a subreport

If the subreport will be linked to the main report, make sure the underlying record sources (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) are related (relationship: An association that is established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.) before using this procedure.

ShowCreate a subreport in an existing report

  1. Open the report you want to use as the main report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Make sure the Control Wizards tool Button image in the toolbox (toolbox: A set of tools that is available in Design view for adding controls to a form or report.) is selected.
  3. Click the Subform/Subreport tool Control in the toolbox.
  4. On the report, click where you want to place the subreport.
  5. Follow the directions in the wizard dialog boxes.

ShowIf the wizard doesn't start

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later.

For more information about sandbox mode, see the Office Online article About Microsoft Jet Expression Service sandbox mode.

When you click the Finish button, Microsoft Access adds a subreport control (subform/subreport control: A control that displays a subform in a form or a subform or a subreport in a report.) to your report. It also creates a separate report that is displayed as the subreport.

ShowAdd an existing report to another report as a subreport

Applies to:
Access 2003