How do I fill a text box with a result from a query.

[boogi]

Hello. I'm using access 2000.
My problem should be easy to solve but I don't seem to get how.
I have a form with a text box which I want to autofill with a result that I get from a query.
The query works just fine.
I'm trying to do that with the expression builder, but it doesn't work, I always get the error "#name?" in the text box.
How should I do it?

 

[jebry]

Hi!

You can use DLookUp:

=DLookUp("YourField", "YourQuery", "YourCriteria&quot

hth
Jeff Bridgham
bridgham@purdue.edu