Hi - I have a form, with a multi-select list box, I am using this code to populate the list box
On a button press event, how can I capture what values were selected from the list box?
Code:
Private Sub Combo2_AfterUpdate()
Dim strSql As String
strSql = "SELECT ID, txtName, [CVN] & ' - ' & [SNV] AS FullInfo FROM AllData WHERE txtName = """ & [Forms]![Form1]![Combo2] & """ ORDER BY txtName;"
'Debug.Print strSql
Me.List11.RowSource = strSql
End Sub
On a button press event, how can I capture what values were selected from the list box?