Create batch of records at a time.

[Guest]

I have a form to create ticket/permission and print it out once I create the
ticket/record. However, I find it too tedious to create one record at a
time. Many times, I issue multiple tickets to the same person for the same
class.
I'm thinking about putting 2 text fields on the form to allow me to specify
a range of tickets numbers, say ticket# 40 to 60 (20 tickets for the same
person, same class, same date, etc). If any could shed some light on how to
write the code for this form to do automatically create that batch of records
and automatically print them out, I'd really appreciate it...this would save
lots of clicking.

The form has the following field: recordID (autonumber), ticket#, ticket
class, dateissued, issued_to/customername.

thanks.

 

[Duane Hookom]

Generically....
You can create a table of numbers (tblNums) with a one numeric (Num) and add
records with values 1 - [SomeHighNumberGreaterThanYourNeeds]. You can then
add this table to any query where you need to generate multiple records from
a single record.

Set the criteria under the Num field to:
Between [Enter Starting Ticket Number] And [Enter Ending Ticket Number]
I would actually get these values from a text box on a form.