Error when canceling the print dialog

[Rafael Bélanger via AccessMonster.com]

I have a problem with printing a report, when the print dialog pops up and
you decide to print theres no problem but when i cancel, it generates a error
message because the runcommand was stopped. Am i forced to print or is there
a way to cancel?

the lines are
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria
DoCmd.RunCommand acCmdPrint

Also, im wondering if there is a way to make the dialog appear without having
to open the report so i can just print right away, i dont need to see it.

 

[Rick B]

Change acViewPreview to acViewNormal to print without preview.

 

[Allen Browne]

Add error handling to your procedure.
Trap and ignore error 2501.

If error handling is a new idea, see:
http://allenbrowne.com/ser-23a.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Rafael Bélanger via AccessMonster.com]

Thx guys, it works fine now