Forum Discussion
Solved
#Error in unbound text box
Hello Experts, I am trying to display nothing instead of #Error being displayed in an unbound text box. Its only showing on the new record row. The below is not working. It still displays #Erro...
Use Nz to return a non-existing value for letterOfCreditID if it is Null:
=DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & Nz([letterOfCreditID],0) & "")
If ID was text, Criteria should read:
"[LCID]='" & Nz([letterOfCreditID],0) & "'"However, here it is numeric, so no quotes, but I keep the closing double-quotes to keep the syntax and tell, that nothing is forgotten:
"[LCID]=" & Nz([letterOfCreditID],0) & ""A matter of coding style, I guess. Just like I prefer spelled variables like this and not abbreviated like ltrOfCrdtID
ahh so its a style. Ok. I like hearing expert's different approaches. Thanks for adding that bit of info. I also see an advantage to spelling out instead of abbreviating.
