Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jan 19, 2025
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...
access
  • Gustav_Brock's avatar
    Gustav_Brock
    Jan 20, 2025

    Use Nz to return a non-existing value for letterOfCreditID if it is Null:

    =DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & Nz([letterOfCreditID],0) & "")

     

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jan 19, 2025

Break the complex formula down and make sure each of the sub elements returns a value correctly. Then slowly add back elements one-at-a-time.

I'd start with 
DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & [letterOfCreditID])

Does that always return a value when used as the control source for the unbound text box?