Print Dialog opens TWO times?

[waldemar]

I have this menu entry in an access application, that is just opending the regular Print dialog:

=DoCmd.RunCommand(340)

However, after clicking ok, the dialog REappears a second time... Does anybody know, why? How I can avoid this behavior?

 

[waldemar]

Nobody ever had this problem? How do you implement a Print Dialog?

 

[waldemar]

Ahhh that was it.... I guess that known runtime error isnt handled by the menu onAction and (strangely) causes the print dialog to reappear a second time. Putting that whole thing into a 100% code function with error handling solved the problem.

Short for everybody having the same problem:

Instead of Inserting

=DoCmd.RunCommand acCmdPrint

into the Action Property of the Menu item

use

=printDialog()

and put

Function printDialog()
On Error Resume Next
DoCmd.RunCommand acCmdPrint
On Error GoTo 0
End Function

(or any nice error handling code) into a global module.