John,
thanks for the tip. It sounds very good to me !
Arnon,
thanks for jumping in. No, your aren't missing something. I've already tried the text box, but had problems with records marked for deletion, with refresh after adding or deleting records an so on ...
>Hi Vlad ----
>
>A good bulletproof way to do it is:
>
>Create a view in your database:
>
>CREATE SQL VIEW vueRecCount AS SELECT CNT(*) AS mytablerecs FROM mytable
>
>Add this view to the DE of the Form where you want. To show it, add a TextBox and bind it to vueRecCount.mytablerecs. If an Add or Delete changes the record count, then a simple =REQUERY('vueRecCount') resets the total records.
>
>>Is there any control which I can place on a form and it will show the number of records in one table from the DE ?
>>
>>Thanks in advance !
Vlad-Georg