MoveLast moves to the last record in your recordset hence you cannot move to a next record, as there isn't any, hence the error.
Anyway, you're on the wrong track.
MoveLast moves to the last record in a recordset, which is not necessarily the last entry in your table.
To retrieve the last entry, you need an identifier (for instance, an autonumber column) which tells you what the last entry is.
If your table meets this requirement, you can retrieve the last entry by using the Max function, either in VBA or in a static query.
RV
