Populating textbox with num of total record with result from a select count query

[shydoc]

How to populate a textbox in a form the number of total record in a particular table.



In the forms textbox, this is what I did but its not working.

control Source: =[select Count(*) from tblname]

but getting #NAME?

How can I solve this problem. Thank you.

[amrut]

try =Dcount("*","tblName")
You can add criteria too like =Dcount("*","tblName","[tblField]>10")

[chuki2]

Yes, use Dcount to count...

Let say :

me.countTextBox=Dcount("idUser","tblUser")

Hope can help you

[shydoc]

try =Dcount("*","tblName")
You can add criteria too like =Dcount("*","tblName","[tblField]>10")

=Dcount("*","tblName") is what I needed, Thank you very much amrut and chuki2