Create a subreport - Access - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Create a subreport

Applies to: Microsoft Office Access 2003

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.

Show Create a subreport in an existing report

Open the report you want to use as the main report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
Make sure the Control Wizards tool in the toolbox (toolbox: A set of tools that is available in Design view to add controls to a form, report, or data access page. The toolset available in page Design view is different from the toolset available in form and report Design view.) is selected.
Click the Subform/Subreport tool in the toolbox.
On the report, click where you want to place the subreport.
Follow the directions in the wizard dialog boxes.
If 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, at http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010489351033.

For more information about sandbox mode, see the topic 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.

Show Add an existing report to another report as a subreport

Open the report you want to use as the main report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
Press F11 to switch to the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.).
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 (subform/subreport control: A control that displays a subform in a form or a subform or a subreport in a report.) to the report.