Multiple Copies of Report Print!

[RichB]

I have a report that I print from a button on a form. The report takes the information directly from the form. The problem I am having is that when I select to print the report it may print 3,4,5, and sometimes up to 30 copies. I have been over and over the settings and cannot find it. I tried to code it to only print 3 copies and it printed 3 times 3,4,5, or whatever it feels like.

Does this sound familiar to anyone?

Thanks
RichB

 

[spacepro]

I have previously used the following code to print 3 copies only of a particular record. You should be able to adapt the code to your ends.

 Dim strDocName As String
 Dim numcopies As Integer
Dim strLinkCriteria As String
numcopies = 3
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
strDocName = "Delivery"
strLinkCriteria = "[ID] = Forms![frmhold]![ID]"

DoCmd.OpenReport strDocName, acViewPreview, strLinkCriteria, "ID = [Forms]![frmhold]![ID]"
DoCmd.PrintOut acPrintAll, , , , numcopies
DoCmd.Close acReport, "Delivery"

Basically setting numcopies for the number of copies required and then using the printout command to carry this out.

Hope this Helps

Andy

 

[R6Flyer]

Sounds more like a problem with the record source for the report.

Have you tried running the query to see what results it is giving - I would hazard a guess that you have several linked tables in the query and it is creating duplicate records.

Cheers

Flyer