How to show the record count of the table used on a form ?

B

barret bonden

How to show the record count of the table on a form ? I'd like to just use
a function to display this number in a text box
I've tried setting the default value of a text box to
=RecordCount
=[CurrentDb].[RecordCount]
=Forms!d_main!RecordsetClone.RecordCount

and other vairatons; I'd rather not use code and record sets. Wouild like
to keep it simple ...
 
T

tina

if the table is bound to the form, then just put an unbound textbox control
in the form's footer, and count the primary key field (which always has a
value in it), as

= Count([NameOfPrimaryKeyField])

hth
 
Top