Saving Report using form fields as part of the name

[teriwinkle]

I have a report generated by a dynamic query. I want to save the report using two fields, [NvrNumber] and [JobNo]. For example. I would like a report to be named "NvrReport_24_3000" where "24" is the [NvrNumber] field and "3000" is the [JobNo]field on the form. For the next report it ,might be "NvrReport_25_3001", or "NvrReport_25_3000", depending on the values of those two fields.


I open the report as follows, but how would I add a command to save the report so that it will save each report using those two fields, in the format above?


DoCmd.OpenReport "rptNvr_QBF", acPreview, , strWhere


Thank you for yoru help!

Teresa

 

[wemeier]

You could use the OutputTo method instead of the OpenReport method. For example:

DoCmd.OutputTo acOutputReport, "rptNvr_QBF", acFormatRTF
, "NvrReport_" & [NvrNumber] & "_" & [JobNo]

This creates the report in rich-text format (RTF) with the name as you require. You can also add a fully-qualified path to the front of the name to put the report into a path other than the current path:

DoCmd.OutputTo acOutputReport, "rptNvr_QBF", acFormatRTF
, "C:\My Documents\NvrReport_" & [NvrNumber] & "_" & [JobNo]

Cruising the Information Superhighway
_{(your mileage may vary)}

 

[teriwinkle]

Thank you for your help! I especially like being able to save it where I want it. It works great!

Teresa