Print button problem

sselby

New member
Local time
Today, 08:30
Joined
Sep 16, 2014
Messages
2
Hi Everyone,

1st of all I am new to this site and I would just like to thank everyone who posts and answer posts on here. I am pretty new to MS Access and this site and the users have helped me a lot.

I am having an annoying problem with a print button on a report which seems to always want to print 2 copies everytime the button is pressed.

I have the following code programmed into an 'On Click' event procedure and the problem is present on every PC the database is running on.

Option Compare Database

Private Sub Command12_Click()
DoCmd.RunCommand acCmdPrint
stDocName = "rptMOShortageReport"
DoCmd.OpenReport stDocName, acNormal
End Sub

Any help on where i am going wrong would be gratefully received.

Thanks

Steve
 

Users who are viewing this thread

Back
Top Bottom