ADO EditMode Property

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

ADO EditMode Property

The EditMode property returns an EditModeEnum value that specifies the editing status of the current record.

Syntax

objRecordset.EditMode

Example


If objRecordset.EditMode = adEditInProgress Then
   If MsgBox("New Record Added", vbYesNo) = vbYes
      objRecordset.Update
   Else
      objRecordset.CancelUpdate
End If

 

EditModeEnum Values
Constant Value

Description
adEditNone 0 No editing operation is in progress
adEditInProgress 1 The current record has been edited but not saved
adEditAdd 2 The current record in the copy buffer is a new record and has not been saved in the database
adEditDelete 4 The current record has been deleted