need help urgent: please query ==> text box

[cyberprop]

im doing an assignment and need to know how to return the result of a query into a text box on a form. Can this be done?

i have tried expression builder using the control source of the text box as =([Number of Hours]![Number of Hrs])
(thats the query)

but it doesnt work

the value the query uses is selected from a combo box then run by a command button. could anyone help please.

ooh and its urgent as it do in tomoorow so could anyone suggest something u may save my life.
thanks in advance

cyberprop

[This message has been edited by cyberprop (edited 04-21-2002).]

 

[Rich]

Not another Student left it to the last minute. Use DLookup on the query.