utilizing the DoCmd OutputTo Method and leaving the OpenFile blank so it prompts for the file name, is there a way you can set the filename and still have it open the output to dialog where the user can choose the path but the filename is already set in the dialog ?
Dim pdfFile As String...