count data from subform
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
but this did not work. Does anybody knows how to do this?