use field value as a pdf filename

[ppsandy]

I have "Access 2003" & "PDF Creater" installed and it can help me to save the report's pages in single pdf file. Now, I have to save the filename with the report field value (e.g. customerid + receipt_no)!! Anyone can help me PLS!!

 

[vbaInet]

This is what most people use:

http://www.lebans.com/reporttopdf.htm

 

[sxschech]

How do you run the pdf creator in code, if it is similar to this, then you can use variables into the filename. Here is an example from a different pdf creation program, but may be similar:

Call RunReportAsPDF("rptReportName", stPath & "PDFFileName" & stCustID & streceiptno & ".pdf", , PrintChoice)

Otherwise you could do the rename after the file is created:

' "Rename the report" to the final file name
Name pdfsourcename As pdfsourcename & stCustID & stReceiptNo

If the ID and Receipt are on a form, then you can use forms!nameofform!ID rather than stCustID

ID would be changed to the object name such as txtID if that is what you call your text box containing the ID.