My issue is that I want to use that query result on a form as an unbound field but the field just shows "#Name?".
What am I missing? If there is a query with a field that you want the textbox to show, why is the control unbound? Then again, the query has several fields so what exactly is supposed to be shown in the textbox? Surely not the values from all the fields in the query... Have to wonder if the form is bound or not. So many questions, so little info.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.