Using recordset.recordcout

[Guest]

Hi!
I have in my form current event this:
lbl1.Caption = Me.Recordset.RecordCount

Its working allright but first after i have clixk to record number 2, when
the form is open i get the value 1 record ???

regards
alvin

 

[ruralguy via AccessMonster.com]

The RecordCount is not guaranteed accurate until you have done a MoveLast!
So your code should be:

Me.RecordSetClone.MoveLast
Me.lbl1.Caption = Me.RecordSet.RecordCount

 

[Guest]

Or maybe:

Me.RecordSetClone.MoveLast
Me.lbl1.Caption = Me.RecordSetClone.RecordCount

Barry

 

[Guest]

Thanks

Alvin


"Barry Gilbert" skrev:

Or maybe:

Me.RecordSetClone.MoveLast
Me.lbl1.Caption = Me.RecordSetClone.RecordCount

Barry