Count function

  • Thread starter Thread starter nick
  • Start date Start date
N

nick

I am using a form to set criteria to return records in a
sub-form. The sub-form is in a datasheet view.
I would like to put a calculated text box in the main form
to count the number of records returned in the sub-form. I
have tried; =Count[forms]![backlog]![Orders], no luck.

This must be simple but I just can't get it to happen

Can anyone help?

Nick
 
If the subform control is named "Orders", this should give you the number of
records:
=[Orders].[Form].[RecordsetClone].[RecordCount]

If that returns 1 when there are more records it the subform, it may be
necessary to ReCalc the form.
 
Back
Top