Table: tblIssue - (IssueID, ParentIssue, ChildIssue)
Query: qryParentIssue
Form: frmNewServiceCalls
Combo Box: cboParentIssue
List Box: lstChildIssue
My combo box gets info from qryParentIssue (only field in the query to make values unique). Everything afterwards I apparently havent the slightest so as of now, no need to post my SQL and VBA. Unless requested lol
I have Unique Values as Simple for my list box.
I have used an example from one of the major users/"experts" on here. They suggested for someone else to use their Cascade Combo Box example as a reference. So I took the same advice. Didnt have much luck, but I also dont want cascading combo boxes. I just want someone to make a selection from the combo box and generate data into the list box. e.g. User selects "Vending Machine" (cboParentIssue) from combo. All possible issues (lstChildIssue) then make selection(s) from the list--as a multi-select list. Then that data (issues selected) will be used.
My tables tblIssue and tblServiceCalls are related through IssueID.
If anyone needs additional info, Ill respond as soon as I see it.
Thanks!