Recordset.CancelUpdate

Cancel any pending updates for a Recordset object.

Syntax
      expression.CancelUpdate(UpdateType)

Key
   UpdateType  The type of update, as specified in Settings 
               (ODBCDirect workspaces only).

Use the CancelUpdate method to cancel any pending updates resulting from an Edit or AddNew operation.

If a user invokes the Edit or AddNew method and hasn’t yet invoked the Update method, then the changes can be cancelled. The EditMode property of the Recordset will show if there is a pending operation that can be canceled.

Examples

Dim db As Database
Dim rst As Recordset

Set dbs = OpenDatabase("Northwind.mdb")
Set rst = dbsNorthwind.OpenRecordset("Employees", dbOpenDynaset)
      
With rst
   .AddNew
   !FirstName = "Fred"
   !LastName = "Bloggs"
   .CancelUpdate
End With

“Even God cannot change the past” ~ Agathon

Related

Update - Save a recordset.
OpenRecordset - Create a new Recordset
AddNew - Add a new record to a recordset.