Count in an Unbound Textbox

[ddrew]

Im sure this has been asked before but I cant find a thread.
I have a form tht has an Unbound textbox on it. I need it to show the total records in a table (not the table that the form is associated to). I know I need to use the count functio but cant find a simple explanation of it. I guess its somethinkgon the lines of:

=Count(tbl_Contacts)

but that just shows #Error

 

[Addyman]

Use DCount and count a particular field in the table:

Me.MyTextBoxName = DCount("FieldName","tblName")

 

[missinglinq]

Or simply

Me.MyTextBoxName = DCount("*","tblName")

Linq ;0)>