Use text box's Control Source property to display query result?

[sjh]

Hi,

My report is based on one query. But to display some information on the report header, I need to run a different query. Is it possible to use the text box's Control Source property to display the result of the query?

If there's no easy way, I guess I will have to execute a SQL statement in the VBA code.

Thank you!!
SJH

 

[dhookom]

You can't put a SQL string in a control source however, you have several options:
1) Use DLookup() or other domain function
2) use a subreport based on the table/query
3) use code to grab the value and place it in the control
4) Add a query that returns only one record to the record source of the report
5) probably others...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.