Export Filtered Microsoft Access Report and Subform Data to Excel
Question details
Export filtered Access report records and related subform data to Excel using the criteria already entered on a form.

- 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.
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.
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.
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.
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.
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.
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.
Write the filtered query results to an Excel template with VBA
Use a template when the exported workbook needs a customized layout that the Access report export cannot preserve.
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.

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.




