Unanswered: Populating a textbox from a Select statement...
I'm a long-time member, but never posted that i can remember. I'm having an issue with populating a text box on a form with data retrieved from the following select statement. Can someone please tell me what I'm doing wrong or if this is doable at all?
I'm using this select statement as the control source on a text box. When i go into Form View, field only shows "#Name?".
In all honesty, this is the first time I've attempted such a thing. I've been googling with no success. The Dlookup should work as i am only returning one value, but i've never attempted it either. Do you have an example of what it should look like based upon my query above?