Need help in exportwithformatting

[amjedakrem]

Hi access experts,
I need a help in writing the format of the name of pdf file I would save after I press "save" button in Report through Macro. I want it to be like it (invoiceId) in the format of "000000" then (customer name) then ".pdf"
Thank you in advance

 

[arnelgp]

instead of using Macro, use [Event Procedure]:

private sub button_click()
DoCmd.OutputTo objecttype:=acOutputReport, _
        objectname:="report_name_here", _
        outputformat:=acFormatPDF, _
        outputquality:=acExportQualityPrint, outputfile:=Format([InvoiceID], "000000") & [customer name] & ".pdf"
end sub