Using form to save multiple records to table

[beewerks]

Hello everyone,

I've got a form that is used for tracking products with unique serial numbers. I want to enter a product in the form and then depending on the order we get, select a quantity of product which would then make as many identical rows in the table as needed based on the before selected quantity. All of the product lines would be identical except for the serial number column, which I have set to Auto_Number. I hope this makes sense.

Below is my INSERT INTO command button code:

Private Sub cmdSave_Click()
'save data to table
CurrentDb.Execute "INSERT INTO [Product_SN_Tracking](ModelNumber, PartNumber, Description, PowerRating, WorkOrder) " & _
" VALUES('" & Me.txtModel & "','" & Me.cboPart & "','" & Me.txtDescription & "','" & Me.txtPower & "','" & Me.txtWorkorder & "')"
'clear cells on form after save
Me.txtDescription = ""
Me.txtModel = ""
Me.txtPower = ""
Me.txtWorkorder = ""
Me.txtSerial = ""
Me.cboPart = ""
End Sub

Where or how would I allow for duplicate rows of records to be inserted into my table?



Thanks!
Alex

[rpeare]

Just create a loop for x many items

if your current code works just embed it in a loop, for instance if you have a quantity field on your form

Let's say your quantity field is named QUANTITY

for i = 1 to QUANTITY
     currentdb.execute (... put your current code here if it works...)
next i

reset your fields here per your original code

This would create duplicate records and assuming your target table [product_sn_tracking] had an autonumber serial number you'd be just fine.

[beewerks]

Ha! It works! It's so simple too. Thanks so much for your help. All of my searching couldn't find this loop function.

Just create a loop for x many items

if your current code works just embed it in a loop, for instance if you have a quantity field on your form

Let's say your quantity field is named QUANTITY

for i = 1 to QUANTITY
     currentdb.execute (... put your current code here if it works...)
next i

reset your fields here per your original code

This would create duplicate records and assuming your target table [product_sn_tracking] had an autonumber serial number you'd be just fine.