My DataObjects field is a combo box display field. I want to take all of the checked values from the combo box and show them in a list box. In my table “L3Process”, the “DataObjects” field takes values in a comma separated list (i.e. 1,2,3,4,5). In design view, the “DataObjects” field is classified as a “number”.

List68 is a list box which is bound to the ID field of the table. I think that part of it is working but I’m getting a type mismatch error. I’m thinking it’s trying to return a number but it’s getting a comma separated list.

Private Sub List68_AfterUpdate()

    Dim strSQL As String
    strSQL = "select ID, DataObjects from L3Process where ID = '" & List68 & "'"
    Me.List71.RowSource = strSQL

End Sub