Record number display in VBA

i would like to thank those people who helped me to overcome my PREVIOUS problem

my new problem is that i would like to display the number of records in a given table in a text box on a form which is bound to that table. i am working in VBA Access- so any help please?

Will U get the account of this table's recordsets??U can use ADO object to realize it with adding the reference of MS ADO!

i made it clear what i wanted, and i am making this project in MICROSOFT ACCESS XP with VBA (2000 fotmat) the fields whithin this entity are

contact name
Address line1
Address line2
Address line3
postcode
telephone

i am a beginner and would really like simplistic help and not use technical (eg ADO????) explanations as that would just make me more baffed. thanx

U can visit this site to get tutorial: http://www.functionx.com/access/

It's pretty difficult to program without a basic understanding of the components you use as a programmer. You can start by searching http://msdn.microsoft.com/library for the ADO documentation and find how to use the recordcount property.