Count records on sub-form and show count on main form 1

[puforee]

I have a main form that has the TAB object. Within each TAB is a sub form. I would like my users to know if there are any records within each subform without having to click the tab. So, for each subform I want to show a count of its records on the main form...just above the TAB name.

Any ideas?

Thanks,

 

[dhookom]

You could place count text boxes in the subforms and then reference these text boxes from text boxes on the main form. You should also be able to use DCount() based on the record source of the subform and any filtering such as Link Master/Child.

Duane
Hook'D on Access
MS Access MVP

 

[puforee]

dhookom.....good suggestion...I will give that a try. First suggestion first...looks the simplest.
I will get back with the results. Thanks,

 

[puforee]

dhookom....this worked very well. I thank you for the insite...and so simple..the best way. You get a star for this one.