I'm trying to save a file in a specific location on my hard drive.
The location should be m:\Order acknowledgment\Customer name\Order number.pdf
The customer name is in a field in my form "match" this varies
also the Order number is in a field in the form under "Order number"
This is my Code but it doesn't work
Private Sub Command240_Click()
Dim Match As String
DoCmd.OutputTo acOutputReport, "Order Confirmation", acFormatPDF, "m:\Order acknowledgement\" " str.Match "\" & Me.Order number & ".pdf", True
End Sub
What did I do wrong I'm new to VBA please help
The location should be m:\Order acknowledgment\Customer name\Order number.pdf
The customer name is in a field in my form "match" this varies
also the Order number is in a field in the form under "Order number"
This is my Code but it doesn't work
Private Sub Command240_Click()
Dim Match As String
DoCmd.OutputTo acOutputReport, "Order Confirmation", acFormatPDF, "m:\Order acknowledgement\" " str.Match "\" & Me.Order number & ".pdf", True
End Sub
What did I do wrong I'm new to VBA please help