Neither dlookup or dcount worls in vba

[dcavaiani]

findcust = Mid(Me.Text0, InStrRev(Me.Text0, " ") + 1) & " " & Left(Me.Text0, InStr(Me.Text0, " ") - 1) ' If Nz(DLookup("[city]", "customers", "[customer]= '" & findcust & "'")) Then If DCount("[city]", "customers", "[customer]= '" & findcust & "'") > 0 Then

The findcust HAS the proper value in it and the customer field in the customers table has that same record (Primary Key), but the "THEN" code is not done ?

 

[Ranman256]

=DCount("*", "customers", "[customer]='" & findcust & "'")

=DLookup("[city]", "customers", "[customer]='" & findcust & "'") & ""

these work, I use them everyday.
if customer is a string.

 

[dcavaiani]

=DCount("*", "customers", "[customer]='" & findcust & "'")

=DLookup("[city]", "customers", "[customer]='" & findcust & "'") & ""

these work, I use them everyday.
if customer is a string.

Yes, I find that works as well as long as it is the control source of a field on the Form

 

[dcavaiani]

Yes, I find that works as well as long as it is the control source of a field on the Form

I'm sorry, I was looking at another line of code which was after the THEN - WHICH (the Then) WAS WORKING - DUH !