Combobox CustRequester wist telkens de inhoud van het 1e record in de tabel. De rest klopt.

Private Sub cmbCustRequester_AfterUpdate()

cmbCustRequester.Requery

End Sub

Private Sub cmbCustRequester_NotInList(NewData As String, Response As Integer)

If Not (NewData = “”) Then

cmbCustRequester.RowSource = “SELECT ‘” & NewData & "’ FROM UNION SELECT DISTINCT FROM "

Response = DATA_ERRADDED

End If

End Sub

(Limit to list = no)

Waarom ben ik telkens de inhoud van dit veld in het 1e record kwijt?