Text box showing #name?

[redbull]

I am trying to display a record on a form. So I have a form with alot of text boxes... I changed the control source using the wizard...
=[QueryName]![ColumnIwant]


But while in form view, the text box shows #Name? .... I am certain that it is a small detail I missed along the way, any recommendations?

[June7]

Try not using the query name.

I don't use the wizards. They confuse me more than help.

[redbull]

So should I run a make table query? I ussually try to avoid the wizards as well, but I am facing one MONSTER of a deadline and I thought it would be quicker... Boy was I mistaken. I am horrible at access stuff, but fairly solid at vba.. Would it be easier to use vba?

[Missinglinq]

What is the RecordSource of the Form? Is ColumnIwant a Field in that Table/Query?

If the answer to the second question is 'Yes,' you simply select the Control and go to Property - Data and select the Field from its dropdown box.

If the answer is 'No,' you'll need to use the DLookup() Function to retrieve the data.

Linq ;0)>

[redbull]

There is no recordsource of the form, it's blank. I just tried making the recordsource the query I want, but then I lost all my text boxes and such... So I removed that.

ColumnIwant is a field on the query.

SO now knowing that I will have to use the Dloopup function, I have been playing with that syntax and I can't get it to retrieve what I want.

[redbull]

GOT IT!, thank you both for you help!

[June7]

Why not a bound form?

If the form was not bound, setting RecordSource property should not 'lose' textboxes. I don't understand this.

[Missinglinq]

FYI, if you add a RecordSource and 'lose all your Textboxes,' it means that

1. Your Form is Bound
2. There are no Records in the RecordSource
3. New Records cannot be added

Only when all three of these things are true does this phenomenon occur.

The reasons for #3, above, are numerous. The most common one is that the RecordSource is a Multi-Table Query that is Read-Only. For reasons why Multi-Table Querie that is Read-Only see Allen Browne's article:

http://allenbrowne.com/ser-61.html

Linq ;0)>