Dear Friends,

How can I retrieve the last record from a table to textbox on form?

I am using MS Access Database.
Application : VB6 (ADODB Recordset)
Table Name is : ERecords
There are 3 fields in the Table:
1) ID (Autonumber - Primary Key)
2) EName
3) Position

I need to retrieve the last record from ERecords table ("ID" Field) in a textbox called txtLastRecord on Employees Form.
How can I do it?