Hi,

This may seem like a stupid question, but I don't know how to do this...

I have a form with a subform on it. What I would like to have is that on my main form, I have a 'box' that displays me the number of records on the subform. So it should basically count the number of record that or on the subform that is related to the active form. How can I do this?

I have tried to use
=count(Form![FormName]!Form![SubformName]![NameOfFieldToCount])
but this did not work. Does anybody knows how to do this?

I found a way to make it work...

I use

=[Forms]![frmMainForm]![frmSubFormOnMainForm].[Form].[RecordsetClone].[RecordCount]

or in my case

=[Forms]![frmOpvTT]![frmSubformOpvTTDetail].[Form].[RecordsetClone].[RecordCount]

and it works...