pdf issues

[bigmac]

hi all, can you help please.
I need to save a report to pdf and have it use the contents of two text boxes as the pdf name all on a click of a button.
example text box 1 contains "testing" text box 2 contains "123", name of the pdf will be "report name testing 123 pdf"
if this is possible can you show me in a sample database please?
cheers

 

[AlexHedley]

You'll want to look into the "OutputTo"

http://msdn.microsoft.com/en-us/library/office/ff192065.aspx

expression .OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding, OutputQuality)

Example:
DoCmd.OutputTo acOutputReport, "", acFormatPDF, myPath + strReportName, True

You could then build you the name of your Report using the controls on a Form or the Report.

Forms!frmNAME!txtName