I am trying to generate new records based on the user filling out a field [Units]

What I want to happen is that it will automatically create the number of records entered into the [Units]field.

Does anyone know what this is called so I can look it up?

You need to give more information. What does the database look like before the transaction, what data is entered, and what do you want the database to look like after the transaction.



mmcdonal

THis is basically what I want to happen.
Scenario:

A salesperson will create a quote that includes the customer information, [#ofUnits] and the [quote#]. [tblQuote]

When they enter the [#ofUnits] on this form and click a button [cmdcreateJobs] it opens a template which asks for the vehicle information.

There is another button [cmdaddparts] where the salesperson will choose the parts and packages that will be used to describe all the units. I will call this the template for all vehicles.

ie #units = 5000
all vehicles are Chevrolet Tohoes 2007 and receive package 1

when they click another button [cmdCreatejobs] the PK and job#'s are created and the template ([quotenumber] followed by sequencial numbering Q-RABA-2/29/07(1)-1 (first unit), Q-RABA-2/29/07(1)-2 (Second Unit) etc on through 5000.)

Basically I am trying to avoid the salesperson from entering the same thing 5000 times.

Unfortunately, I need individual records for this because each unit is billed rather than the group of vehicles.

Do you need any other information. I looked into it and I think I need to do a For...NextLoop. What I do not know is what one looks like.

I think you already have the code for this to open a connection and recordset. So open those outside the loop. Then in the loop, put your code to create a single record. Then do this:

Dim i, iNoOfUnits As Integer

Take variables
iNoOfUnits = 5000

Create Connection
Create Recordset

set counter to 0
i = 0
'Since i = 0, then you can loop until i = 5000, which will loop from 0 - 4999.

Do Until i = iNoOfUnits
   sUnit = "Q-RABA-2/29/07(1)-" & i
   rs.AddNew
   rs("Field1") = sUnit
   ...
   rs.Update
   i = i + 1
Loop

rs.Close
cn.Close

Regardless of whether you use a For Next, or Do Until Loop, ALWAYS increment the counter, otherwise you will create a million records all with the same values until you just have to dump the database. The increment is the i = i + 1.

Did that help?


mmcdonal