Access97, Text Box & Control Source

Can a SQL query be used in Control source of a text box?

e.g. Select Count(*) From MyTable;

I have tried but it does not work. I have requirement where by different value to be display in text boxes.

Any solution is welcomed, whereby I can use the SQL directly in the Control Source.