Count Records on a Subform while on the Main Form.

C

cbayardo

I have a Form and Subform, I want to have a textbox on the Main Form that
counts the records in the subform. I don not want to count all records, just
some, based on a criteria.
Is this possible?
I am trying with:
=Count([EventEmployee subform].[Form]![EmployeeID])
But I get and error on the text box
Thanks
 
S

SteveM

You could use a query as the source of the field on your main form.
You could also use a field in the Footer of your subform and do the
calculation there. You can then reference that field on your main form.

Steve
 
Top