Record Count

  • Thread starter Thread starter Nick
  • Start date Start date
N

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
 
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?
Click to expand...
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
 
Back
Top