Set Textbox 'Control Source' to be a Query?

[reimondo]

Hi,

Is it possible to set the 'Control Source' of a text field box to be a query? The text box is unbound (ie. not a physical field in the database tables).

I've already got the query and it works fine when I execute the query by itself. But when I assign the query to the 'Control Source', I get a #Name error when I load the form. So I'm now thinking whether Access supports the assignment of a 'query' as a 'control source'?

Any help will be much appreciated.

Thanks,

Raymond

 

[Rich]

DLookup or use a subform or a UnionQuery, you can't do directly unless the form is bound to the query