Solved How to hide the #error in an unbound DLookup field (1 Viewer)

[brandywinefarm]

Hello.
I have a form that has a drop down box that looks up the referrerID from a contact table (integer).
Then I have an unbound field that reports that person's name for the user.
It works fine. However, if there is no one that referred that client, the referrerID field is null and so the unbound field shows "#error".
Control source for that unbound field =DLookUp("[FirstName] & ' ' & [LastName]","people","peopleid=" & [frmReferrerID])
Is there any way I can hide this text so the data entry person doesn't get confused by this #error?
I have searched and tried a few code snippets but nothing seems to work.

 

[arnelgp]

try:

=DLookUp("[FirstName] & ' ' & [LastName]","people","peopleid=" & Nz([frmReferrerID],0)) & ""

 

[brandywinefarm]

That works. Please help me understand. Before I tried to use ISNULL to return a "" into the field but it never worked.
Isn't it proper to use ISNULL on a blank integer field?

 

[arnelgp]

Before I tried to use ISNULL to return a ""

there is no need to test if it is Null, since the amended code will work whether the field is Null or Not.

 

[The_Doc_Man]

Stated another way, the NZ function "hides" the actual ISNULL test behind the scenes and performs the substitution if ISNULL would be TRUE. By hiding the test, NZ lets you make a safer operation that will avoid the pitfalls of null encounters.