Data Import & Export

Export Filtered Microsoft Access Report and Subform Data to Excel

Natalie TaylorNatalie Taylor Nov 22, 2026 868 views

Question details

Export filtered Access report records and related subform data to Excel using the criteria already entered on a form.

Export Filtered Microsoft Access Report and Subform Data to Excel
Product
Microsoft Access and Microsoft Excel
Device & OS
not provided
Scenario
A user selects criteria in combo boxes and text boxes on an Access form, then needs the matching report and related subform data in Excel.
Observed behavior
The export should use the existing form values without asking the user to enter the criteria again.
Before you start

Identify the filter form and control names, the report's record source, and the tables or queries supplying the subform. Keep the filter form open with the desired criteria selected while testing the export.

Solution 1Recommended

Export a query that uses the existing form filters

Use a saved query to combine the report and subform data and apply the criteria already entered on the form.

Exporting a query provides the underlying records, but it does not reproduce the report's layout. A one-to-many join can repeat parent record values for each related subform record.

1
Create the export query

In Access, select Create > Query Design. Add the report's source tables or queries and the tables or queries used by the subform, then join them using their related key fields.

2
Add fields and criteria

Add the fields needed in Excel. In the Criteria row for each filtered field, reference its form control, such as [Forms]![frmFilter]![cboCustomer]. Replace the example names with your actual form and control names, and replicate any additional report or subform filters.

3
Test and save the query

With the filter form open and populated, select Run in Query Design. Check that the results include the expected related records, then save the query with a name such as qryFilteredExport.

4
Export to Excel

Select the saved query in the Navigation Pane, then choose External Data > New Data Source > From Database > Excel if available, or use the Excel option in the External Data export group. Choose the workbook path and complete the export wizard.

Check the export command: Access menu labels vary by version. If the export prompts for parameters or cannot resolve the form references, keep the form open and check the names; alternatively, use VBA to resolve the query parameters before writing the records to Excel.
Free Microsoft Office alternative

Review exported Access data in WPS Spreadsheets

After exporting the query from Microsoft Access, use WPS Office as a free, lightweight alternative for reviewing and editing the workbook. Its familiar interface and Excel format support make it easy to move existing spreadsheets into WPS.

Review and filter exported Access records in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesWork with a familiar spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why export the query instead of the Access report?

A query can combine the underlying report and subform records in a spreadsheet-friendly table. Exporting a report to Excel may not preserve its original appearance.

How does the query reuse values from the filter form?

Enter references such as [Forms]![frmFilter]![cboCustomer] in the query's Criteria row, using your actual form and control names. Keep the form open with the desired values while running or exporting the query.

Why does the export show repeated parent records?

When a parent record has multiple related subform records, a one-to-many join produces a row for each related record. The parent fields therefore repeat on those rows.

Can I keep a specific Excel layout?

Yes. Create an Excel template and use VBA to open the filtered query as a recordset and write its data to a specified worksheet and starting cell. Check the finished workbook to confirm the template layout meets your needs.

What should I check if Access asks me for a parameter?

Make sure the filter form is open and that the query references the correct form and control names. If the export still cannot resolve the references, set the query parameters from the form controls in VBA before opening the recordset.