Need to change caption of report prior to printing.

H

Hypercoder

I need to print an access report from the button click of a form, and i need
the file to be sent to the printer with a certain name (Usually Access just
uses the report caption as the print file name).
The command I use is:

DoCmd.OpenReport "report1", acViewNormal

I tried implemting the event handlers Open and Acivate on the actual report
to try and set the Caption property just before print, but it does not seem
to work. Does anyone know how to get this to work or have a better idea to
print with a certain print job name?

Thanks
 
Top