Hello All,
I'm trying to export a report to PDF. The report has 11 sub-reports (formatted to fit 11 pages in report). When I open the report in print preview all 11 pages show up perfectly. When I click the export button I've built, 11 pages get exported but the last page is blank. If I close the PDF, then click the export button on the report 10 pages get exported, but the last page (page 10) is blank. If I close the PDF, then click the export button on the report 9 pages get exported, but the last page (page 9) is blank. So it seems that every time (while the report remains open) I click the export button a page gets "trimmed" off the report.
The odd thing is that I have another report with 11 sub-reports that is based on another query that exports fine. The report in question is based on an aggregate query while the report that is exporting property is based on a regular select query. Seems awfully strange how it "trims" a page every time export button is clicked. Here is the code behind the button...seems very simple. I'm using Access 2016. Thanks in advance for any help.
Private Sub cmdExportPDF_Click()
Docmd.OutputTo acOutputReport, "rptContractSummary_MasterRFP", acFormatPDF, , True
End Sub