Calculated Control formula

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

I have a subform with fields: First Name, Last Name, Phone, Expiration Date,
Membership Status. I want to create a calculated control to display the total
number of records appearing in the subform. How would I do this?
 
I haven't tested this, but try as the control's control source:

=SubformControlName.Form.Recordset.RecordCount

Where SubformControlName is the name of the subform control on the main
form, not the name of the form identified as the Source Object in the subform
control's properties.
 

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

Need correct formula 1
Help - Need calculated control to work 1
Need calculated control to work 4
Need calculated control to work 1
Problem with Group By & Max Rcd 5
Counting multiple memberships 1
Access Reference Subform's Control 0
calculated control event order 2

Back
Top