This is probably a simple issue, but none of my search results seem to have a solution. I am trying to insert 4 text or combo box values and an item from a list box. The values for the 4 combo/text boxes stays the same for each listbox item. However all of the solutions seem use the .ItemSelected property. I need it to go though each item without the user having to select items. Here is where I am so far.
Code:
For intRowCtr = 0 To lst.ListCount - 1
strShipSQL = "INSERT INTO Shipping (ShippedBy, Company, OrderNo, TrackingNo, ShipMethod, ShipDate) VALUES ('" _
& Me.cbxShippedBy & "','" & Me.cbxCompany & "','" & lst.Column(0, intRowCtr) & "','" & Me.tbxShipTracking & "','" & Me.cbxShipMethod & "',#" & dtShipDate & "#)"
CurrentDb.Execute strShipSQL
Next