Displaying Total Amount Of Records In A Table

[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

 

[Jerry Whittle]

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")

 

[John W. Vinson]

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.