Returning Record Count From SubForm

[raychuck]

I have a Meeting Form, and on that form is a Attendance Sub-Form. I want to count the number of Attendance records and fill in a Attendance Number field on the Meeting form. Access2000 online help references counting records in reports, but, how would I do this using forms and subforms? Any help would be appreciated greatly. Thanx in advance

Ray . . .

 

[Jack Cowley]

Take a look at the DCount() Function in Help...

 

[raychuck]

Thanks

 

[Travis]

There is also the RecordsetClone Property of the SubForm.

Forms![ParentForm].[SubForm].Form.RecordSetClone.RecordCount

 

[Happy YN]

Travis this seems to be counting only the number of records visible at the outset on the subform but not if there are more records which need to be scrolled into view
Any ideas?
Thanks

 

[Happy YN]

Travis this seems to be counting only the number of records visible at the outset on the subform but not if there are more records which need to be scrolled into view
Any ideas?
Thanks