Form / subform - need to count occurances

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a form and need some help. I want to count the number of occurances in a subform for a particular parent record (in the main form). How can I build an expression to do that?

Any ideas?
 
You could use the record count of the subform as you move to each new
record:

Me.NameOfSubformControl.Form.Recordset.RecordCount

You could also use the DCount function on the subform's record source
passing the linked field as a parameter.

--
Wayne Morgan
Microsoft Access MVP


Daniel Barkowitz said:
I am building a form and need some help. I want to count the number of
Click to expand...
occurances in a subform for a particular parent record (in the main form).
How can I build an expression to do that?
 
Back
Top