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

  • Thread starter Thread starter don
  • Start date Start date
D

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
 
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



don said:
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
Click to expand...


.
Click to expand...
 
Back
Top