I have a list box (List68) that on change I want to use the bound id column of the list to query a multivalue field based on the id of that column. I want the values (for viewing only) to be added and displayed in another list box (List71). There is a one to many relationship between L3Process.ID and L3Process.DataObjects.

Private Sub List68_AfterUpdate()

    Me.List71.RowSource = "SELECT DataObjects.ID, DataObjects.DataObjects, 
    L3Process.ID FROM L3Process INNER JOIN DataObjects ON 
    L3Process.DataObjects.Value = DataObjects.ID 
    WHERE L3Process.ID = '" & List68 & "'"


End Sub

Nothing happens when I change the values of List68