Count entries in subform

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a main form Pat1 (PK=PatiID), the main form has a tab control
embedded on it. Each tab on the control then has a subform (eg
frmAdmissionReason). The subform is linked to the master form by field
fkPatID.What I would like is to be able to count the occurences in the table
that the subform is bound to where PatID=fkPatID and then have a text box
that would read like.

Previous Admissions _____of _____

I have learned over the last year that coding is not a skill I excel at.

Please help.

Thanks
 
In the text box on the main form, you want to show the number of records in
the subform?

Set the ControlSource of the text box to something like this:
=[frmAdmissionReason].[Form].[RecordsetClone].[RecordCount]
 
Back
Top