ADODB Object
 
Syntax
 
recordsetobject.MovePrevious
 
Description
Moves the position of the current record pointer back to the previous record.
 
The MovePrevious method is called to move to the previous record in the specified Recordset object.
 
If the Recordset does not support bookmarks and is using a forward only cursor, then an error will be generated when you call this method.
 
If you are at the first record, calling this method will put you at BOF and the BOF property will be set to True. If you are at BOF and call this method, an error will be generated.
 
This is one of four methods belonging to the Recordset object that allow you to navigate or move through a data record. The other three are, MoveFirst, MoveLast, and MoveNext.
See Also
Example
 
objRecorset.MovePrevious
If objRecordset.BOF = True
   objRecordset.MoveFirst
   MsgBox "At First Record", vbOK
End If