counting records in subform

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
 
A

Allen Browne

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]
 
C

chriske911

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