I have a form that is being filled in (Access 2013). When completed, the click event of a button on the form when clicked creates a PDF file using the following:
START OF CODE
DoCmd.OutputTo acOutputReport, "rptCustomer", _
acFormatPDF, "C:\Intake\PDFs\GetSignature.pdf"
END OF CODE
The PDF file is being named GetSignature. It will be saved with the CustomerID as part of the name. CustomerID is a field in the form. I would like to name the form with the CustomerID instead of naming it GetSignature. For instance, CustomerID is 12345. I want the file to be named 12345.
What do I need to change to do that?
Thank you.
START OF CODE
DoCmd.OutputTo acOutputReport, "rptCustomer", _
acFormatPDF, "C:\Intake\PDFs\GetSignature.pdf"
END OF CODE
The PDF file is being named GetSignature. It will be saved with the CustomerID as part of the name. CustomerID is a field in the form. I would like to name the form with the CustomerID instead of naming it GetSignature. For instance, CustomerID is 12345. I want the file to be named 12345.
What do I need to change to do that?
Thank you.