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?