brandywinefarm
New member
- Local time
- Today, 05:20
- Joined
- Jan 27, 2023
- Messages
- 4
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.
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.