I have tried implementing the code provided in the following solution for multiselect listbox:
My code is attached to the After Update property of the listbox, & looks like the following:
Private Sub List10_AfterUpdate()
Dim stritems As String
For Each var In Me!List10!ItemsSelected
stritems = stritems & "," & Me!List10!Columns(0, var)
According to the solution, this should produce "a comma separated list of all items" selected in the listbox. However, when I run the code I get an MS Access code that it can't execute the code in design mode.
Should the VBA code work, would the selected items be passed to a query field as the following criteria: