Export report to PDF with automatic naming

[sakurasanta86]

Hello,I want to automatically save a report to a pdf with automatic naming by clicking a button:- report name : rptTest- name of the pdf-file : number-initials-date.pdf (e.g 2156598-SRU-20171222.pdf)I am getting the error message "The action or method requires a Report Name argument."What am i doing wrong?I used the following code :Private Sub Command0_Click()On Error GoTo Err_Command0_ClickDim Number As StringDim Initials As StringDim Date As StringDim Filename As StringDim Path As StringNumber= Me.Number.ValueInitials = Me.Initials.ValueDate = Year(Now()) & "" & Month(Now()) & "" & Day(Now())Filename = Number & "-" & Initials & "-" & Date & ".pdf"Path = "D:\Documents\Projecten\Database" & FilenameDoCmd.OpenReport rptTest, acPreviewDoCmd.OutputTo acOutputReport, "rptTest", acFormatPDF, Path, TrueExit_Command0_Click:Exit SubErr_Command0_Click:MsgBox Err.DescriptionResume Exit_Command0_ClickEnd Sub

[June7]

Please format code with CODE tags to retain line endings and indentations so we can read it easier. I am not inclined to try and decipher as it is.