Hi
I have been trying to put some code behind a button that will allow me to export a pdf report version of what a user has selected on a form, I want the file name to default to fields from the form and I want the user to be able to specify where to save the file. I have stolen bits of code from various places on the internet and have got it to work beautifully with the file names but it doesn't allow the user to browse and specify where they want it saved.
Private Sub Command61_Click()
DoCmd.OutputTo acOutputReport, "QuoteView", acFormatPDF, "C:\Users\User\Documents" & _
Forms![quoteview]![CustName] & "STQ000" & Forms![quoteview]![QuoteNo] & " .pdf"
End Sub
Is what I want to do possible?
Once again, any help would be greatly appreciated. Your help so far has proved invaluable.
Cheers
Julie