Printing Emergency

[Guest]

the following is the VB code I am using to print records from my database. I
need to be able to print multiple records at one time, how can I do this.
Normally the form can have anywhere between 5 to 100 records. Right now I
have to select each record one at a time in order to print. Please help.

Dim stDocName As String
stDocName = "Call Profile - Individual Call"
DoCmd.OpenReport stDocName, acViewNormal

Thank you so much for your assistance

 

[John W. Vinson]

the following is the VB code I am using to print records from my database. I
need to be able to print multiple records at one time, how can I do this.
Normally the form can have anywhere between 5 to 100 records. Right now I
have to select each record one at a time in order to print. Please help.

Dim stDocName As String
stDocName = "Call Profile - Individual Call"
DoCmd.OpenReport stDocName, acViewNormal

Thank you so much for your assistance

Make a copy of the report which is (badly mis-)named "Call Profile -
Individual Call". Change the Query upon whihc it is based to use criteria
which return the records that you want to see. Knowing nothing about your
database design or the structure of your form, I don't know what those
criteria might be - but take a look at your Form's recordsource property for a
good start.

John W. Vinson [MVP]