Export Report Into Word Named By Text Box

[on-2]

Hi

I have a report which i export to a rtf doc to be opened in word. I have found the output to in a macro to save me going through the file menu. I can see a space to save and name the doc to a specific file i.e. C:/Exports/report.rtf but it would save loads of time if this could pick from a field in the open record. I have tried c:/exports/"Forms![details]![refno]".rtf and some variations on this but it doesnt seem to gel. Is this possible ?

 

[Oldsoftboss]

Try:

" c:/exports/ " & Forms![details]![refno] & ".rtf "

Personally I would use a Common Dialog Box to store full path.

Dave

 

[on-2]

No still no good im sure its something simple and it will all work nicely. (Cool little example by the way)