Need to print range of records.

D

Dorian

I have a button on my form which prints the current record, using:
DoCmd.PrintOut acSelection
What I need to do is to simulate the pressing of this button for
approximately 1000 new records. These records were just added and the users
need a print of each one.
Is there an easy way to accomplish this?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
D

Dale_Fye via AccessMonster.com

Dorian,

Does it generate a report for the current record, and print that? If so, you
could modify the query so that the report returns all 1000 records.

Another method I have used for sending emails is to selected recipients is to
generate a recordset, then loop through the recordset, changing the value of
an unbound control on a form, and using that value to generate the report
automatically.

HTH
Dale
 
Top