How to run formating code on a report when exporting to pdf

[Sck]

I have a report that runs formatting code in the load event. However, the report is normally saved off as a pdf so I added a button with the following code:



strPath = Application.CurrentProject.Path & "\" & Me.cboCA.Column(1) & ".pdf"
DoCmd.OutputTo acOutputReport, "rptCAA", acFormatPDF, strPath

this works but the formatting code is never triggered. I have tried adding the code in several different report events but can't seem to get it to run when the above code runs.

Any help is appreciated!

[June7]

Might have to open the report in Print Preview then do the export of the open report.

[Sck]

That is what I have been doing and it works but it adds several more "clicks" to the process. This report can be run 20+ times in a row and it gets to be a bother.

[June7]

Why is it run 20+ times in a row? Why are there more clicks?

[Sck]

it is run on different customers.

Click count to save as pdf from form view:
click to open the report
R-click to bring up shortcut menu
click to save as pdf
Enter name
click OK

[June7]

The single click to open report can also do the export and print and close report, all in one procedure. The OutputTo will use the open report.

As for naming the document, could this be automated based on some data in the record or have user input this in a textbox before executing code?

And printing multiple customer reports can also be automated if the customers can be selected by some filter criteria. Open recordset object in VBA and cycle through records.

[Sck]

didn't think about open - export - close.......

The naming is automated based on the customer but the selection of customers is for the most part random. I could pull based on activity but that would still miss a number of them.

Thanks! solved the issue!