Displaying Total Amount Of Records In A Table

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")
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"dmills" wrote:

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

On Wed, 17 Mar 2010 08:34:05 -0700, dmills
wrote:

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

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.
--

John W. Vinson [MVP]