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