Count registered members on Home form

[thudson]

I want to count how many current members our club has from a field (tick box), but the problem is I want to display it on the Home Form and not in the table where the data is.


I have a query on the field which lists the fields that are true.
The expression Count(Reg19.Reg19= True) does not work on that query.
I have tried Dcount as well!
I have a report that counts the number of records, but don't how to get this data to display on the Home Form.
How can I get this information to the form where I want it?

[Gicu]

Try Dcount=("*","[YourTableName]","[YourRegistrationYesNoField] = True")