Display Record in label

If I am moving through a recordset by movenext with a sql statement of limiting by 2 how can I display what record I am on in a label.
LVL 8
thenoneAsked:
Who is Participating?
 
Raynard7Connect With a Mentor Commented:
If you want the number of the record to display then you can use a counter to determine it.
If you want an id - then you can refer to that id.

I am guessing that you are doing this through a module;

So you can address the forms through

forms("formname").Controls("lableName").caption = Count_Value
or
forms("formname").Controls("lableName").caption = rs!ID_Field

and then

forms("formname").Refresh
forms("formname").Repaint
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
use the recordsets's absolutposition  property, which starts at 0
0
 
thenoneAuthor Commented:
Thanks Angel I get the picture.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.