Count recordset in a suform

[Stingfish]

My question has two part.

Firstly, Im tring to count the number of records in a form which is a child to the parent form. Ive place an unbound text box on the main form to show the count of records of the second formbut its not working.

I tried the followig in the controlsource
=Count([subfrmAction])????

Then I want place in the main form something like this becuase the 2 form has default view as single form.

Whats the display the result of the count on the main form e.g
The client has ? actions to be completed

 

[Pat Hartman]

If you have navigation buttons showing on the subform, you should be able to see the number of records there. Do you really need it on the main form also?

 

[Stingfish]

Thanks Pat
you are so right. I guess i just wanted to the no. in the recordset to stand out.

 

[Pat Hartman]

The easy way to do it is to add a footer to the subform and add a control that counts the rows. You can then reference that control in your main form.