how to get 'select count' sql result into form textbox

[don]

I'm trying to jsut get 1 field result from 'Select
Count..' SQL statement into form textbox...i tried setting
the textbox control source property to the sql statement,
but that didntseem to work. Assuming i need to code the
sql in vba, but not sure how to get the sql result
assigned to the textbox..
Thanks for any help!
Don

 

[MikeB]

I'm trying to jsut get 1 field result from 'Select
Count..' SQL statement into form textbox...i tried setting
the textbox control source property to the sql statement,
but that didntseem to work. Assuming i need to code the
sql in vba, but not sure how to get the sql result
assigned to the textbox..

http://www.experts-exchange.com/Databases/MS_Access/Q_20936278.html

a couple of DAO and ADO solutions.

 

[Joe Fallon]

Me![txtCount] = DCount("*", "tblName")

 

[don]

thanks Joe!!! that was the ticket!!!

now i can head out to beach..i appreciate!!!!

Don

-----Original Message-----
Me![txtCount] = DCount("*", "tblName")
--
Joe Fallon
Access MVP

I'm trying to jsut get 1 field result from 'Select
Count..' SQL statement into form textbox...i tried setting
the textbox control source property to the sql statement,
but that didntseem to work. Assuming i need to code the
sql in vba, but not sure how to get the sql result
assigned to the textbox..
Thanks for any help!
Don

.