General discussion

Locked

Access97, Text Box & Control Source

By NetMan_OVO ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access97, Text Box & Control Source

by Karpi In reply to Access97, Text Box & Cont ...

hello,

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

try instead DCOUNT,DSUM etc

HTH
karpi
yfluctuat nec mergitur>

Collapse -

Access97, Text Box & Control Source

by NetMan_OVO In reply to Access97, Text Box & Cont ...

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

Collapse -

Access97, Text Box & Control Source

by NetMan_OVO In reply to Access97, Text Box & Cont ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums