Print dialog box

[Mike Faulkner]

Hello

OS: Windows XP
App: Access XP

Any VBA code to display the Print dialog box would be much appreciated. I
use dialogs() in Word.

Regards
Mike

 

[MikeJohnB]

Try the following code

DoCmd.OpenReport "The_Name_of_Your_Report", acViewPreview
DoCmd.RunCommand acCmdPrint

This opens the dialog box prior to printing

hth

Mike B