Print dialogue box

[f9073341]

Hi guys,

I'm trying to print a report without actually viewing it and I've been messing around with this statement:

'DoCmd.RunCommand acCmdPrint'

Is there anyway you can pass a report name to this command so it knows what to print (if printing what you're not viewing)?

I would simply preview the report and bring up the print dialogue box once opened, but the dialogue box ALWAYS comes up first!

Many Thanks

 

[MarkK]

What about DoCmd.OpenReport?

 

[Poppa Smurf]

Use DoCmd.OpenReport "report name", acViewNormal,

The name of your report must be enclosed in double quotes.