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

  • Thread starter Thread starter barret bonden
  • Start date Start date
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 ...
 
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
 
Back
Top