Discussion Locked

Access97, Text Box & Control Source

0 helpful

3 replies

by rakeshkanojia Jun 29, 2003 last reply Jun 30, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

hello,

afaik ther is no possibility to use a sql-statement directly for recordsource.

try instead DCOUNT,DSUM etc

HTH
karpi
yfluctuat nec mergitur>

Thanks Karpi, this "D" works for me :-)

This question was closed by the author

This discussion is closed to new replies.