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]
 

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

Access Daily Entry with multiple entries per field 0
Multiple subforms 0
adding and removing subforms from subform controls 4
Subform not allowing data entry 4
Backtabbing between SubForms on TabControls 2
referring to Subform Total in main form 1
Access Reference Subform's Control 0
Refresh Data in a subform 2

Back
Top