Multiple Values in Single Recordset

[AcceSs-AbLe]

Hi,

I have a list box which contains multiple values for the user to select. These values are stored in a recordset. However, my problem is that when the user selects single value, the value is stored in the table, if there is more than 1 selection, nothing is stored in the recordset. How would I accomplish this?

Thank you!!!

 

[AcceSs-AbLe]

I came up with the following code which produces the results but I still can't figure out how to put this into a cell(recordset)

Sub BoundData()
Dim frm As Form, ctl As Control
Dim varItm As Variant
Dim rs As Recordset
Set frm = Forms!Form1
Set ctl = frm!List0
For Each varItm In ctl.ItemsSelected
Debug.Print ctl.ItemData(varItm)
rs.Update ctl.ItemData(varItm)----this doesnt work
Next varItm

End Sub