The MoveLast method on a Recordset object moves to the last record in a specified Recordset object and makes that record current.
recordset.MoveLast
None.
The MoveLast method is used to move the current record position to the last record in the recordset. The Recordset object must support bookmarks or backward cursor movement; otherwise, the MoveLast method call generates an error.