Counting Records *SOLVED*

Say i've got 154 records in my table and when I scroll through the records I want to be able to display which record it is and how many records there are in the table. New records are always added to the table so the total number of records needs to change when a new record is added.

In a label I want it to display something like.......002 of 154

Lintz

What re you using?

VB front end to a .mdb,

Access (VBA),

etc.

yeah, my app is linked to an Access DB.

Anyone got any ideas?? This is the code i've got but I can't get the current record number to display, only the record count is displayed.

Code:

---

Private Sub Form_Load()
Label52.Caption = Format("000") & " of " & Format(datPrimaryRS.Recordset.RecordCount, "000")
End Sub

---

Unless you need the leading 0's, just use something like this.

VB Code:

me.rs.movenext
Label1.Caption = Str(Me.rs.AbsolutePosition) & _
" of " & Str(Me.rs.RecordCount)

I needed to put the code behind the Next and Previous cmd buttons. It is working just how I planned it. Thanks all for your suggestions.

Lintz :cool: