|
View Full Version : Returning Record Count From SubForm raychuck 04-12-2002, 07:20 AM 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 04-12-2002, 07:28 AM Take a look at the DCount() Function in Help... raychuck 04-16-2002, 11:48 AM Thanks :-) Travis 04-16-2002, 12:39 PM There is also the RecordsetClone Property of the SubForm. Forms![ParentForm].[SubForm].Form.RecordSetClone.RecordCount Happy YN 04-10-2003, 03:04 PM 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 04-10-2003, 03:10 PM 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 |