How display Auto-refreshing counter ?

[mscertified]

I need to display on a form the number of records in some other table. The
count needs to autorefresh on a timed basis.
The table will be continually updated (with both Inserts and Deletes) by
other users and other processes. This is a multi-user split database in
Access 2003.

Thanks.

 

[Klatuu]

Use the Form Timer event.
Set the Timer Interval to the value necessary to refresh as you want it.
The value is in milliseconds, so 1000 is 1 second.

Then in the timer event, execute a DCount function.

Me.txtRecordsInTable = DCount("*","TheTableName")