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

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
 
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TextBox Object Control Source Expresion, trouble with 3
I'm not sure how to return the value using the SQL statement? 5
SQL as Textbox Control source 3
Query results in a listbox control 2
Using SQL Query Code in Form Module to Return Record Count 2
Display result of crosstab query in form 1
changing the syntax of an SQL Select statement to appease VBA 4
Expression Builder basic question on syntax / Or / how to incorporatea SQL query into a textbox cont 16

Top