I am trying to output a selection of two page reports from access as pdf files with the customer name as the pdf filename for each two page report.

If I select 100 records for the report, I get 100 two page reports. If I print to the Adobe PDF driver, I get one PDF file with 200 pages. I tried to set the caption property in the report to "= [CustomerName]" which only made the report name "= [CustomerName]".

Is there is an Access setting to do this? What VBA code would accomplish the task?

I have Acrobat Pro and tried the batch function ... with no success. Any ideas?