counting records in subform

  • Thread starter Thread starter chriske911
  • Start date Start date
C

chriske911

I'd like to count records in the one subform and display them in the parent
form header

I think I need dcount but don't know exactly how to refer to the subform and
how to build the criteria

thnx
 
Show show a count of the number of records in your subform, add a text box
with this in its Control Source:

=[NameOfYourSubformControlHere].[Form].[RecordsetClone].[RecordCount]
 
tnhx a bunch,

grtz
Allen Browne said:
Show show a count of the number of records in your subform, add a text box
with this in its Control Source:

=[NameOfYourSubformControlHere].[Form].[RecordsetClone].[RecordCount]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

chriske911 said:
I'd like to count records in the one subform and display them in the parent
form header

I think I need dcount but don't know exactly how to refer to the subform and
how to build the criteria
Click to expand...
Click to expand...
 
Back
Top