Hi,
I have 3 queries in my user form, 1st level, selects and saves (bounded) major category, the 2nd is based on the 1st level and that is also bounded (both are cbo boxes), the 3rd is based on the 2nd selection and is a list because I want multiple values to be selected. Problem 1) I have this and I can save all the data into a table. But I can't seem to get only the data the user selects, I get all the data available.
SELECT tblItemParts.ItemParts, tblItemParts.MinorCategory INTO tblItemsBroughtIn
FROM tblItemParts
WHERE (((tblItemParts.MinorCategory)=[Forms]![frmLimView].[cboUnit]));
I also tried this - but it doesn't work, it doesn't crash which is great but doesn't work.
Private Sub lstItemsIn_AfterUpdate()
Dim frm As Form, ctl As Control
Dim varItm As Variant, intI As Integer
Set frm = Forms!frmLimView
Set ctl = frm!lstItemsIn
For Each varItm In ctl.ItemsSelected
For intI = 0 To ctl.ColumnCount - 1
Debug.Print ctl.Column(intI, varItm)
Next intI
Debug.Print
Next varItm
End Sub
2) Problem 2, I want to concatenate the correct (only user) selection from tblItemsBroughtIn into a field in my tblMainData and save it to the correct RecordID.
Help would be greatly appreciated.
Thanks,
Vanessa