Show Subform's Record Count on Main Form?

T

tbl

Is it within the realm of logic to have a main form display
the number of records on its subform?
 
O

Ofer Cohen

In the text box that located on the main form, conrol source you can write

=[SubFormControlName].Form.RecordsetClone.RecordCount
 
T

tbl

In the text box that located on the main form, conrol source you can write

=[SubFormControlName].Form.RecordsetClone.RecordCount


Hehe, I like it!

Thanks Ofer
 
T

tbl

In the text box that located on the main form, conrol source you can write

=[SubFormControlName].Form.RecordsetClone.RecordCount


That worked beautifully. Thanks Ofer.


If I wanted to get even more involved...

Could I put two totals controls on the main form, where one
of them would show the subform total for records where
Field1 = "A", and the other would show the subform total for
records where Field1 = "B"?

Would this be getting into the land of "probably more
churning than it's worth"?


As you can see, I'm getting some of the basics down with
RDB's and MS Access, but I have no idea how the big kids are
doing things.
 
Top