This property indicates the editing status of the current record in a Recordset object.
object.EditMode
The following table shows the possible return values for EditMode.
Constant |
Value |
Description |
| adEditNone | 0 | No editing operation is in progress. |
| adEditInProgress | 1 | Data in the current record has been modified but not yet saved. |
| adEditAdd | 2 | The AddNew method has been invoked, and the current record in the copy buffer is a new record that has not been saved in the database. |
Use the EditMode property to determine the editing status of the current record. If an editing process has been interrupted, you can test for pending changes and determine whether you need to use the Update or CancelUpdate method.
For more information about the EditMode property under different editing conditions, see the AddNew method.
The following code example sets the constants for the EditMode property.
Const adEditNone = 0
Const adEditInProgress = 1
Const adEditAdd = 2