AddNew

Syntax

recordsetobject.AddNew [FieldList][, Values]

Description

Use to create a new record.

The AddNew method is called to create and initialize a new record that can be added to an updateable Recordset. The provider must support adding new records.

There are two optional parameters.

Since the parameters are optional, there are two ways to use the AddNew method, with or without the arguments. If you do not use parameters, then you will need to call the Update or UpdateBatch methods. When you use the optional parameters, ADO will automatically perform the update. However, if you are doing batch updates, you will still need to call the UpdateBatch method.

Parameter	Description
Values	The optional Values parameter is a single value or an array of values for the fields that you want to populate in the new record. If the FieldList parameter is an array, then Values must also be an array. Further, Values must have the exact same number of members and be in the same order as FieldList.
FieldList	The optional FieldList parameter is a variant that can be a single field name, or an array of field names, or the numeric (ordinal) position of the fields in the new record. For both the single name and array of names, each name must be enclosed within a pair of double quotes. Multiple names in the array must be separated (delimited) by commas.

See Also

EditMode, CancelUpdate, Requery, Supports, Update, UpdateBatch.

Example

MyObject.AddNew "FirstName", "Sasha"

MyObject.AddNew Array("FirstName", "LastName"), Array("Luke", "Skywalker")

varFieldList = Array("FirstName", "LastName")

varValues = Array("Luke", "Skywalker")

MyObject.AddNew varFieldList, varValues

strFirstName = "John"

strLastName = "Doe"

intAge = 826

...

rsData.AddNew

rsData.Fields("FirstName") = strFirstName

rsData.Fields("LastName") = strLastName

rsData.Fields("Age") = intAge

rsData.Update