Hi
With some help from this forum earlier today, I have managed to get the below DLookup expression working to in the Control Source of a textbox.
=IIf([Text63]="Live","Row " & DLookUp("[Row]","[qryLocate]","[Box] = " & [txtBox]),"")
However, it is extremely slow, sometimes up to 15 seconds...