The code could be triggered through the AfterUpdate event, on leaving the Listbox, or through a Command Button. With Multi-Select set to Simple or Extended, the Listbox no longer has a Value Property. You have to retrieve the selected items using the code that Paul's example shows, specifically
Code:
'add selected values to string
Set ctl = Me.lstEmployees
For Each varItem In ctl.ItemsSelected
strWhere = strWhere & ctl.ItemData(varItem) & ","
'Use this line if your value is text
'strWhere = strWhere & "'" & ctl.ItemData(varItem) & "',"
Next varItem
After the code runs, the Variable strWhere holds the selected values you need.
The 'Combobox with Checkboxes' requires using one of the new Multi-valued Fields in 2010. This is something that most experienced developers stay away from, and really should be avoided, I would think, by newbies.
Linq ;0)>