Dlookup two criteria

[ikzouhetnietweten]

I want my textbox FirstName to work.
So I have a Dlookup that has to search for two criteria.
I need to lookup the FirstName field in the table Klanten.
It just stays empty in my form after I click a Customer and contactperson in the comboboxes.
txtnaam contains the customername that it has to lookup aswell in the table Klanten.

Private Sub Contactpersoon_AfterUpdate()
Me.FirstName = DLookup("FirstName", "Klanten", "[LastName]= '" & Me.Contactpersoon & " AND [Klantnaam]= " & Me.txtnaam & "'")
End Sub

 

[Alc]

Private Sub Contactpersoon_AfterUpdate()
Me.FirstName = DLookup("FirstName", "Klanten", "[LastName]= '" & Me.Contactpersoon & "[COLOR=red][B]' [/B][/COLOR]AND [Klantnaam]= [COLOR=red][B]'[/B][/COLOR]" & Me.txtnaam & "'")
End Sub

I think there were two single quotes missing. One before "AND [Klantnaam] and one after (in red above).

 

[ikzouhetnietweten]

Very good, thanks a lot +rep

 

[Alc]

Glad to hear it helped. Did much the same thing myself not long ago.