Record Count

[Nick]

I am trying to count records returned in a sub-form. I was
told from a previous post that this should work;
=[Backlog].Form.RecordsetClone.RecordCount
Backlog, is the sub-form name. It does return a value but
it is not accurate.
I created a text box in the main form and typed it in the
Control Source. I re-query after up-date, the count
changes but is inaccurate.
Can someone point me in the right direction?

Regards
Nick

 

[Jim Allensworth]

I am trying to count records returned in a sub-form. I was
told from a previous post that this should work;
=[Backlog].Form.RecordsetClone.RecordCount
Backlog, is the sub-form name. It does return a value but
it is not accurate.
I created a text box in the main form and typed it in the
Control Source. I re-query after up-date, the count
changes but is inaccurate.
Can someone point me in the right direction?

RecordCount is not reliable until you do a MoveLast on the recordset.

Me.Backlog.Form.RecordsetClone.MoveLast
'Now it will be accurate
Me.Backlog.Form.RecordsetClone.RecordCount


- Jim