DLookup help 1

[WallT]

I use the following DLooUp string on a form to show the company name from the Customers table after I enter an account number on my "Order Form". For some reason the Company Name text box shows as an "Error" until I add the account number. Shouldn't that just be blank until I enter an account number? The Account Number is a "Number" value.

=NZ(DLookUp("CompanyName","tbl_Customers","AccountNumber =" & [DBAccountNumber]),Null)

 

[PHV]

=NZ(DLookUp("CompanyName","tbl_Customers","AccountNumber =" & [DBAccountNumber]),[!]""[/!])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WallT]

That works after I enter the Account Number, but it still shows as an error if the Account Number field is blank.

Do you think it may have to do with the fact that my Forms Record Source is a Query?

 

[PHV]

=NZ(DLookUp("CompanyName","tbl_Customers","AccountNumber=" & Val([DBAccountNumber] & "")),"")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WallT]

Thank you very much...you wouldn't happen to know where I can read an article or something regarding the "Val

 

[PHV]

where I can read an article or something regarding the "Val"
Put the cursor inside the "Val" word in your code and press the F1 key.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886