Outputting A Query Count Into A Text Box

[DAPOOLE]

How can I output a count from a query into a text box?

strSQL = "Select count(*) From test "

Thanks in advance.

 

[namliam]

Lookup the word "recordset" in the access help and see if you can figure it out from there

 

[stopher]

Or maybe this will help:
me.myTextBox=DCount("*","[test]")

Actually you can put the following as the control source for the text box (unbound):
=DCount("*","[test]")

namliam's solution might might perform better in some circumstances though.

Chris