Count Records in Table

[blackie1982]

I have a table which stores records depending on some criteria. But what I need is on the main start page of the database is to display a label saying there are records in that certain table. How do I count the number of records in the table and display the label if records are present?

 

[Mile-O]

Change the label to a tetbox and set it's Enabled property to False/No and its Locked property to True/Yes

In the textbox's ControlSource put:

=DCount("*", "MyTable")

and replace MyTable with the table you want to count.