display the number of table records in a form

[swk003]

Hi, I am having a few problems writing code to display in a form the number of records updated to my table . I have tried to write code with counter incrementation, but hitting problems as my programming is very basic. Someone suggested adding an autonumber field to the data table that I am adding records to and then display the value of the autonumber, Does anyone have any similar code?

thanks

Simon

 

[ZmrAbdulla]

Hi,
Put a label on the form Footer and use this code on the Current Event of the Form. AutoNumber field is not always true because if you delete a row you will be missing that number from the row.

Private Sub Form_Current()
Label1.Caption = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount
End Sub

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com