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

 

[RoyVidar]

Access doesn't support that.

Have a look at the DLookup function in the help files, that might be used as controlsource (or you could open the query as a recordset using VBA and DAO/ADO and assign the value).

Syntax:
[tt]=DLookup("field","table","somefield = somevalue")[/tt]

Criteria part might be omitted.

Roy-Vidar

 

[HockeyGuy]

Change your unbound text box to a combo box. You can set the combo box to only show one row and lock/disable it to prevent data entry into the control.

HTH

Rick