Displaying query results in a text box. How do you do this? 2

[Dherrera]

i cant get the results of a query to display in a text box. the query only has one record and one field in it but it wont display. ive tried setting the default value of the textbox to value of the query but the txtbox shows #NAME! in it. ive tried "ME.txtCULevel= qryUserLevel.userLevel" but i get the same result.

can someone please help me out here.

 

[PHV]

Set the ControlSource property of txtCULevel to something like this:
=DLookUp("userLevel", "qryUserLevel")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Dherrera]

beautiful!!!

thanks PHV that worked just as i needed.