Displaying Total Amount Of Records In A Table

  • Thread starter Thread starter dmills
  • Start date Start date
D

dmills

I would like to display the amount of records that are in a table on the form
- do I use a text box and assign the control source somehow...?

Thank you in advance
 
You could use something like below in the control source on an unbound text
field in the form. I would work best if you put in the primary key field name
in FieldName.

DCount("[FieldName]", "TableName")
 
I would like to display the amount of records that are in a table on the form
- do I use a text box and assign the control source somehow...?

Thank you in advance
Click to expand...

Try a textbox with a control source

=Count("*", "YourTableName")

This will count all the records in the table, irrespective of the recordsource
of the form, which might be a query or might be filtered.

If that's not what you want post back.
 
Back
Top