Output Format argument

[Rusty]

Hi Guys,

I've used the code below to output a report to Word in rtf format:

This allows the user to specify where they want to save the file and under what name. However, does anyone know of a way to set the Output Format argument so that it will save it in the folder "Q:\Paperwork" AND under the file name "invoice" & the value in the [RequestNumber] field of the report? (i.e. "invoice [requestnumber] .rtf")

I've tried several different things within the code below but it doesn't work

Thanks,

Rusty

DoCmd.OutputTo acOutputReport, "rptInvoice Request Form_patient events",
 acFormatRTF, , , ""

 

[Loolaa]

the file and location need to be in a string so try....

"Q:\Paperwork\invoice" & RequestNumber & ".rtf"

L