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.
