Report generates multiple copies

[plcman]

Hi

i have a problem where when a report is generated by the click of a button multiple copies are generated (actually 6 copies every time). Even in preview mode 6 copies are shown of an identical report. There is only one record in the table and so only one matching record.

the code behind the button is:

certificateNo = Me![CertNo]
stLinkCriteria = "[CertNo] =" & certificateNo & ""
stDocName = "Certificate"
DoCmd.OpenReport stDocName, acViewPreview, stLinkCriteria


I have even tried a different printer. Any help would be appreciated.

Thanks

 

[Remou]

What is the query behind the report?

 

[plcman]

Hi

there is no query, the record is selected by the stLibkCriterea as shown above.


Thanks

 

[Remou]

What is the Record Source of the report? That is, what is the record picked from? stLibkCriterea only says which record to pick.

 

[plcman]

The record is picked from a table, as explained above, there is only one record in the table.

Regards

Alan Edwards

85% of statistics that are quoted are entirely made up!