Click on the Next Page button at the bottom of your report to preview page 2.

Hi Kevin
Thanks for this, i feel a bit stupid now!

Can I now save the pdf using 2 of the fields on the form to name it?

John: it's not your fault. It's a quirk in Access that the report preview comes up with the very bottom of the page below the bottom of the Access window so you can't see that. I hate it too. You'll see me complain about it in my videos.

Yes, when you save the PDF you can specify the filename in VBA, or set the report caption and that usually works. Usually. Use the OutputTo command. I cover it here: Export to Word - I use Word in that example, but just switch to acFormatPDF.

Thanks Rich, you are a breath of fresh air mate!

Hi Richard
After a lot of head scratching I have managed to get this to work, thank you.
Question, I can only get it to work with the CurrentPath VBA and not by selecting a folder, C:\... I just get the red text! I think this method only allows me to put in set text to name the file, and not the text from the fields? is there away around this?
Thank you in advance.

How are you writing your path?
Is it enclosed in quotes?

Yeah, your complete path has to be inside of double-quotes. Also, you need to have Admin rights to that folder or else VBA won't be able to create files there.

Not sure how many quotes are needed, the error first highlighted is CDM of "CDM Report"

Try this:

DoCmd.OutputTo acOutputReport, "ProjectReportR", acFormatPDF, "C:\Users\JohnRutter\Desktop\DatabaseReports\" & "CDM Report - " & ProjectPDNumber & " " & ProjectName & ".PDF"

The AutoStart parameter is optional. The default is False so you don't need to specify it unless you want to open the PDF straight away.

I get a Run-time error '2501':

Sorted there is a space between Database Reports in the folder name.  Thank you for your time and patience.
Kind regards John