Hi, I need some help with a DLookup expression in the AfterUpdate event of a form text box, please.
I have a query (qryLocate with two fields, Box and Row
I want to look up the value of text box txtBoxID in the field Box in qryLocate and return the value in Row.
I tried the below but it didn't work, probably because I've not used Dlookup much in Access.
I have a query (qryLocate with two fields, Box and Row
I want to look up the value of text box txtBoxID in the field Box in qryLocate and return the value in Row.
I tried the below but it didn't work, probably because I've not used Dlookup much in Access.
Code:
=DLookUp("[Row]","[qryLocate]","[qryLocate]![Box] = '" & [Me].[txtBoxID] & "'")