Solved Adding surname to .pdf output (1 Viewer)

[Sreemike]

I have a form used to run a report.
I have managed to output the report in pdf form by using the following VBA:

DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\AutoAb.PDF"


But I want to replace the generic AutoAb.pdf with the Firstname and surname given in the form. So the given report pdf will be generated with the name eg: AlanSmith.pdf
That is, I want to insert the Firstname & Surname fields from the form to the name of the .pdf output.
Can anyone help me with this please?

 

[Gasman]

It is called concatenation?

DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\" & Trim(Me.Firstname)  & Trim(Me.Surname) & ".PDF"

HTH

 

[Sreemike]

It is called concatenation?

DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\" & Trim(Me.Firstname)  & Trim(Me.Surname) & ".PDF"

HTH

Brilliant! I was missing the me.name How do I get a space or an _ between the first and surname? Thank you.

 

[Gasman]

Brilliant! I was missing the me.name How do I get a space or an _ between the first and surname? Thank you.

Well I had a - originally, then saw that you wanted it as AlanSmith ?
So just contcatenate whatever you want into the correct place.?

Should be obvious now, I have shown you how. No need for a Trim function with that.

You might not have needed the Me., but I always use it to be clear as to what I am using, matter of habit.

 

[Sreemike]

Well I had a - originally, then saw that you wanted it as AlanSmith ?
So just contcatenate whatever you want into the correct place.?

Should be obvious now, I have shown you how. No need for a Trim function with that.

You might not have needed the Me., but I always use it to be clear as to what I am using, matter of habit.

Thank you very much.
The following code works perfect for me:
DoCmd.OutputTo acOutputReport, "rptPrnTH1TH2", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\" & Trim(Me.Firstname) & " " & Trim(Me.Surname) & "_TH1TH2.PDF"

Many thanks.

 

[Gasman]

You might want to think about putting the Surname first?
Easier to locate files that way, I have found?