Name

recordset.Update([Fields], [Value])

Synopsis

Saves changes made to the current record.

Argument

Description

Fields

The name of the field being updated or an array of names or ordinal positions if you are updating multiple fields

Value

The updated value of the field or an array of values if you are updating multiple fields

See the AddNew code example for an example of using Update.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.