Hello,
I would like to build criteria from selected items of a multicolumn list box. How do I specify the column number that I will use to build the criteria? I only need values from column 1. Thanks
I would like to build criteria from selected items of a multicolumn list box. How do I specify the column number that I will use to build the criteria? I only need values from column 1. Thanks
Code:
Set ctl = Me![lst_fusions]
For Each Itm In ctl.ItemsSelected
If Len(Criteria) = 0 Then
Criteria = chr(34) & ctl.ItemData(Itm) & chr(34)
Else
Criteria = Criteria & "," & chr(34) & ctl.ItemData(Itm) _
& chr(34)
End If
Next Itm