I need a VBA code to print the report

[accessbeginner]

Hi,
I have a report named PIRREPORTFORMD17792. Every time I try to print out a record, the MS Access 2010 uses PIRREPORTFORMD17792 as a default file name.
Instead of using PIRREPORTFORMD17792 as a default file name for all the reports, I would like to use a field on the form for the file name. This field called PIRNO. (This field will automatically generate a number such as PIR20014-0001, PIR2014-0002 and ect. whenever a new record is added.)
Here is an example of what I want:
If I am currently on a record shown PIR20014-0001, then I want the file name of this report (in PDF) to be converted to PIR20014-0001 instead of PIRREPORTFORMD17792. I would appreciate your help a lot.

Regards,

Paul

[Seth Schrock]

I use the DoCmd.OutputTo method to export my reports as PDFs. This allows you to specify the report name in the OutputFile argument. Here is a link to the MSDN website explaining the command: MSDN: DoCmd.OutputTo

[accessbeginner]

Hi Seth,
I am new at VBA code.
Below is the VBA code which I use to print. If you can, could you please show me how to change it? Thank you.

Private Sub Command265_Click()
Dim strWhere As String
 
    If Me.Dirty Then    'Save any edits.
        Me.Dirty = False
    End If
 
    If Me.NewRecord Then 'Check there is a record to print
        MsgBox "Select a record to print"
    Else
        strWhere = "[PIRNO] = " & Me.[PIRNO]
        DoCmd.OpenReport "PIRREPORTFORMD17792", acViewPreview, , strWhere
    End If
End Sub

[zmbd]

Please follow the link that Seth gave you and read how to use the command.
Then attempt to alter your code to use the option given to you by Seth.
If you are still not obtaining the desired results then post back.
Normally, we're not here to write the code for you - that is somehthing you really must do for yourself or you will never benefit from the knowledge.

-z