Count Records on a Subform while on the Main Form.

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose a record without making a subform 6
Access Main form/Subform Navigation 0
Question: Counting subform records on main form 1
Update subform with combobox change on main form 1
Main Form and two Subforms 2
Display Count of records from subform on Main form 7
First Subform record gets modified when closing form 3
Testing Subform Records to make button visible 1

Top