DoCmd.OutputTo acOutputReport, "rpt_summary1", acFormatPDF, PDFPATH & "\" & repName & ".pdf", True, , , acExportQualityPrint
The above code does make a PDF but there are several items on the report that are populated in the ONLoad event -e.g.
Private Sub Report_Load()
Me.txt_fillMe1 = "Some Value"
Me.txt_fillMe2 = "Some other Value"
The report runs perfect in print and preview
But when I use the above OutputTo the PDF is created but none of the controls that are populated in the reports code have anything in them
the code behind the report doesn't seem to run -
Funny thing is - Using the menu Item in Print Preview ribbon on the Data Tab PDF or XPS (this may be an add on by adobe- some confusion) - Anyway - This exports the PDF just fine - If I could do this Menu in VBA this would work