Multiple Report Printing

[andyh]

Quick one?

How do I get a parameter ? box to pop up asking how many copies I wish to print ???

 

[Richie]

Try this
DoCmd.RunCommand acCmdPrint

 

[Pat Hartman]

See the following article at the Microsoft support site.

Q179315 - ACC97: How to Set Number of Copies to Print for Report with PrintOut Method

 

[andyh]

Thanks Guys,

I have looked at the MS site and understand (I think) what they are saying. It seems that you have to pre specify the number of copies and which pages.

I have also tried the Runcommand.printout method

This works well if you want to print the form.

What I need is to have that print box appear (or a parameter box) which will print any number of copies of the report as specified by the user.

I have played around with joining my code for just printing the report for the record (seting stCriteria & stDocName) but I can't seem to marry the two up.

What code (if you know) should I use.

currently the code for the printing of the report for the record is:

Dim stCriteria As String
Dim stDocName As String
stCriteria = "[QAS]= " & Me.Combo44
stDocName = "QS49"
DoCmd.OpenReport stDocName, acNormal, , stCriteria