Display Record numbers in database for Vb6.0

[Stott40]

I need to know how to display the current record number of the total records in a label for a database application.
my code looks like this:
Private Sub Form_Load ()
lblRecDisplay.Caption = " Record " & _
CStr(intCurrentRecNo) & " of " & CStr(intLastRecNo)
what's wrong with this?

 

[dpaulson]

If you're using ADO use
lblRecDisplay.Caption = " Record " & _
rsYourRecordset.AbsolutePosition & " of " & rsYourRecordset.RecordCount


David Paulson