Display count of records from related subform in main form

[grond]

I have a Form, [frmMembers], with a subform, [frmMembers_Subform] which is based on a query.
The subform displays a number of records that are related to the record from the main form, in a datasheet view.


I want to place a control on the main form that displays the count of records returned in the subform.

I'm not sure how to proceed. I thought I could make a calculated control to count the number of instances of each foreign key from the query, but I only succeeded in returning the total number of records returned by the query (not the number of unique foreign keys).

Other than that, I have no idea where to go with it. My attempts to create a function to count the records from the main form have all failed miserably, with the #Name? error.

What do?

[amrut]

Add a textbox in subform's footer(say txtCount).Set =count(SomeControlonSubForm) as its control source. On the main form, add a text box and set it's control source to this text box(=[SubFormName].[Form]![txtCount]). SubFormName is the subform control's name on main form.Use the expression builder to get the correct syntax.

[grond]

Thanks amrut. That got it, I was just janking up the syntax.
I was also confused because the calculated field =count([countfield]) was returning the total number of items from the query, instead of those related to the record I wanted to show, but I suppose that that changes when the main form runs and pulls out the data. Once I popped the pointer into the main form, it worked splendidly.
Thanks again.