When a user presses a command button on my form, I'd like the OnClick code to print and collate 3 copies of a report. My current code prints 3 copies of the report but it does not collate them. The print and collate options work fine when I manually do it (File > Print > ...), but the -1 in the code is not collating. I also tried the code without the -1. Same thing: 3 copies but not collated.
Any other ideas?
Hoving
OnClick code:
*******************************
With DoCmd
.OpenReport "rptSurveys", acViewPreview
.SelectObject acReport, "rptSurveys"
.PrintOut , , , , 3, -1
.Close acReport, "rptSurveys"
End With
*******************************
Any other ideas?
Hoving
OnClick code:
*******************************
With DoCmd
.OpenReport "rptSurveys", acViewPreview
.SelectObject acReport, "rptSurveys"
.PrintOut , , , , 3, -1
.Close acReport, "rptSurveys"
End With
*******************************