Tutorials References Exercises Sign Up Menu
Create Website Get Certified Pro

ADO AddNew Method

❮ Complete Recordset Object Reference

The AddNew method creates a new record for an updateable Recordset object.

After you call this method, the new record will be the current record. 


objRecordset.AddNew fieldlist,values

Parameter Description
fieldlist Optional. A field name, or an array of field names, or the numeric position of the fields in the new record
values Optional. A value, or an array of values for the fields in the new record


rs.AddNew "ProductName","Chang"


varvalues=Array("Chang","19","24-12 oz bottles")
rs.AddNew varfields,varvalues

❮ Complete Recordset Object Reference