Of the ADO objects, only the Recordset object allows users to navigate through a group of records. Only one record within a recordset can be current at a given time. Therefore, the Recordset object supports a number of properties and methods that allow users to navigate through the recordset.
The following table describes properties of the Recordset object that are used to navigate a recordset. For a complete listing of Recordset object properties, read the article "Recordset Object (ADO)" in ADO Help.
| Property | Description |
|---|---|
| AbsolutePage | Sets or returns the absolute page in which the current record exists. |
| AbsolutePosition | Sets or returns the absolute position of the current record (this can be affected by record additions or deletions). |
| BOF | Indicates if the pointer has moved before the first record. |
| Bookmark | Returns a unique identifier for the current record. This property can also be used to move the pointer to a specified record. |
| EOF | Indicates if the pointer has moved past the last record. |
The following table describes methods of the Recordset object that are used to navigate through a recordset. For a complete listing of Recordset object methods, read the article "Recordset Object (ADO)" in ADO Help.
| Method | Description |
|---|---|
| Move | Moves a specified number of records forward or backward. |
| MoveFirst | Moves to the first record. |
| MoveLast | Moves to the last record. |
| MoveNext | Moves to the next record. |
| MovePrevious | Moves to the previous record. |
To see sample code that shows the Click events for various navigation buttons, click on the icon below.