Is it possible to use the name of a text box as a variable in an expression in the same text box. I'm building a floor plan Database, and have a Dlookup function that searches the cubicle name in a table and shows the associated name. Ideally I'd like to be able to copy and paste the boxes, and just change the 'name' of the text box without having to change the formula. I'm trying to make this as easy to update as possible so less technical people can modify layout easily.
My current expression
="1406-347 " & DLookUp("Expr1","FloorPlanQuery","CubeNumber='1406-347'")
I'd like to replace he cube number (1406-347) with an expression that will look up the name of the text box it is in.