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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Access Main form/Subform Navigation 0
Main Form with Subforms 5
Filter on Subform Not Displaying as Expected 1
Subform to Main Form Record Problem 1
Main Form and two Subforms 2
Main \ Sub Form Data 1

Back
Top