Saving Report to Path

[ebizleads]

I need to save a report to a specified path via VB code. The path needs to include a field name.

Save to: c:\dir\[clientid].rtf

Any idea how to do this?

Ebizleads

 

[Remou]

Perhaps:
[tt]DoCmd.OutputTo acOutputReport, "rptReport", acFormatRTF, "C:\Dir\" & Me.ClientID & ".rtf"[/tt]

 

[ebizleads]

hmmm...says I entered an expression that has no value.???

 

[Remou]

What exactly did you use? Have you checked ClientID?

 

[ebizleads]

Maybe this helps. The report is based on a query that prints based on the record in a form. In the ClientID field of the query I have:

[Forms]![Main Lead Console].[ClientID]

I place this code in the report On Open event and got the error stated.

 

[Remou]

Please post your code, otherwise I have to guess.