EditMode Property

           

Returns a value that indicates the state of editing for the current record.

Return Values

The return value is a Long that indicates the state of editing, as listed in the following table.

Constant	Description
dbEditNone	No editing operation is in progress.
DbEditInProgress	The Edit method has been invoked, and the current record is in the copy buffer.
dbEditAdd	The AddNew method has been invoked, and the current record in the copy buffer is a new record that hasn't been saved in the database.

Remarks

The EditMode property is useful when an editing process is interrupted, for example, by an error during validation. You can use the value of the EditMode property to determine whether you should use the Update or CancelUpdate method.

You can also check to see if the LockEdits property setting is True and the EditMode property setting is dbEditInProgress to determine whether the current page is locked.