Print Dialog Box

[earlgrey]

On my forms I have created a Print Current Record button, when the user clicks this button the record is printed out without giving the user an option of which printer to use.

I would like it so that when the user clicks this button the print dialog box is displayed allowing the user to choose which printer to send the printout to, how many copies, etc. Similar to the user choosing File/Print.

My OnClick event procedure for the CmdPrintRecord button is as follows:

Dim stDocName As String

stDocName = "rptLocal Customers Form"

DoCmd.OpenReport stDocName, acViewNormal, "qryPrint Current LocalCust"

This problem is driving me mad, my database is ready for use by staff, but I don't want to release it until this problem is solved. I am using Access '97

Any ideas?

Thanks in advance

Earlgrey

 

[PaulF]

Try this after the print preview command

DoCmd.RunCommand acCmdPrint


PaulF