Printing Problems

Fix a Microsoft Access Report That Prints Repeatedly or Will Not Preview

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

Question details

Identify why an Access report repeats for each subreport record and check whether the same query issue affects Print Preview.

Fix a Microsoft Access Report That Prints Repeatedly or Will Not Preview
Product
Microsoft Access
Device & OS
not provided
Scenario
A main report displays related records in a subreport and needs to print once per primary record.
Observed behavior
The main report repeats once for each subreport record and may not preview as expected.
Before you start

Identify the primary key for the main report records and the field that links them to the subreport records. Open the database in Access and locate both reports in the Navigation Pane.

Solution 1Recommended

Remove duplicate parent rows from the main report record source

Use this approach when the main report prints once for every related subreport record.

1
Inspect the main report source

In the Navigation Pane, right-click the main report and select Design View. Open the Property Sheet, select the report, and check Record Source on the Data tab.

2
Check for duplicate records

Open the query named in Record Source, or use the build button beside the property to inspect it. Run the query and check whether the primary key appears more than once.

3
Revise the main query

In Query Design, remove joins to related detail tables that multiply parent rows when those tables are only needed by the subreport. Keep the main query at one row per primary record; use grouping or aggregation if related values are needed in the main report.

4
Set up the subreport

Open the subreport in Design View and check its Record Source on the Property Sheet's Data tab. Use a separate query that returns the related detail records.

5
Link and test the reports

In the main report's Design View, select the subreport control and check Link Master Fields and Link Child Fields on the Property Sheet's Data tab. Set them to the matching parent and child fields, save the reports, and open the main report in Print Preview.

Remove duplicate parent rows from the main report record source
If Print Preview still fails: Duplicate parent rows can explain repeated output, but they are not the only possible cause of preview problems. Check any error message and investigate other report, printer, or query issues if the preview still does not open.
Free Microsoft Office alternative

Use WPS Office for Documents and Spreadsheets Alongside Access

WPS Office is a free, lightweight, easy-to-use alternative for everyday document and spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. It does not repair or replace an Access database report.

Work with report data exported from Access to a spreadsheet.Open and edit Microsoft Excel XLSX and Word DOCX files.Use a familiar interface for documents and spreadsheets.Move existing Office files into a lightweight, free office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access report print six times when the subreport has six records?

The main report query may return the parent record once for each related detail record. Open the main report in Design View, check Record Source on the Property Sheet's Data tab, and run the query to look for repeated primary keys.

How should I connect the main report to its subreport?

In the main report's Design View, select the subreport control. On the Property Sheet's Data tab, set Link Master Fields to the parent field and Link Child Fields to the matching field in the subreport source.

Should the main report query include the subreport's detail table?

Not if the join creates multiple rows for each parent and the detail records are only needed in the subreport. Use a separate subreport query for those records, or aggregate the detail data if the main report needs a summary.

Will fixing duplicate rows always restore Print Preview?

No. Correcting the record source can fix repeated output and may resolve related preview behavior, but preview failures can have other causes. Check the error message and investigate the report, query, and printer settings if the problem remains.