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