I have an unbound text box, where a user types in a part number, and when he types it in, I want the 2nd text box to populate it based on the first.
My function is:
=DLookUp("[LEGRISPN]","[tblSMCParts]","[SMCPN]=" & [fldtxtsmc])
when I show the form in form mode, it comes back as #Error.
I am using Access 2007.
I appreciate any help
My function is:
=DLookUp("[LEGRISPN]","[tblSMCParts]","[SMCPN]=" & [fldtxtsmc])
when I show the form in form mode, it comes back as #Error.
I am using Access 2007.
I appreciate any help