counting records in subform

[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

 

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

 

[chriske911]

tnhx a bunch,

grtz

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")

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