Move Number Record For Free

DAO is the native data access method for the Jet (Ms-Access) data tables. ADO "Active X Data Objects" is an industry friendly connection to almost all types of database.

Use the MoveFirst method to move the current record position to the first record in the Recordset. Use the MoveLast method 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 method call will generate an error.

When you open a Recordset, the first record is current and the BOF property is False. If the Recordset contains no records, the BOF property is True, and there is no current record. If the first or last record is already current when you use MoveFirst or MoveLast, the current record doesn't change.

To make the first, last, next, or previous record in a Recordset the current record, use either the MoveFirst, MoveLast, MoveNext, or MovePrevious method. Using Move with rows equal to 0 is an easy way to retrieve the underlying data for the current record.

When you open a Recordset, the first record is current and the BOF property is False. If the Recordset contains no records, the BOF property is True, and there is no current record. If the first or last record is already current when you use MoveFirst or MoveLast, the current record doesn't change.

Use the MoveFirst method to move the current record position to the first record in the Recordset. Use the MoveLast method 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 method call will generate an error.

In the upper left, you see the (orange) First Record command button on a form. Underneath, the Control Tip property pops up as you hover over it The command button Caption is &First ... so Alt-F is the HotKey .