Here's what I got going on. I have an Access database with a table called TA. I am making a form to add records to this table. We have a scanner to scan serial numbers in to prevent typo's. I came up with a form to use to support the scanner. Here is what we want to add
All serial numbers in list box will have the same PO #
(txtPObulk) I have a text box asking what the PO is
(lstSystemTag) I have a list box that we put all the serial numbers in.
I want to add all the serials numbers with the PO that was entered into the table TA
I was able to come up with a loop to cycle through the list, but I can't figure out how to add them to the table.
I appreciate the help.
Private Sub Command31_Click()
Dim j As Long
For j = 0 To .ListCount - 1
'MsgBox Me.lstSystemTag.Column(0, j), vbOKOnly, "Item number:" & j + 1