Show Subform's Record Count on Main Form?

  • Thread starter Thread starter tbl
  • Start date Start date
T

tbl

Is it within the realm of logic to have a main form display
the number of records on its subform?
 
In the text box that located on the main form, conrol source you can write

=[SubFormControlName].Form.RecordsetClone.RecordCount
 
In the text box that located on the main form, conrol source you can write

=[SubFormControlName].Form.RecordsetClone.RecordCount
Click to expand...


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.
 
Back
Top