Experts, guess I still dont get the order of the single quotes and double quotes. I get a #error on the below. I have spent an hour on this. Both [LCNo] and [Reference Number] are TEXT.
Do you see where I have made an error?
unbound field on form (names are correct):
=DLookUp("[OldLCNo]","tblLetterOfCredit","[LCNo]= & chr(34) &" & [Reference Number] & " & Chr(34) &")