From http://www.w3schools.com (Copyright Refsnes Data)
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" %> or <% varfields=Array("ProductName","Prize","Quantity") varvalues=Array("Chang","19","24-12 oz bottles") rs.AddNew varfields,varvalues %> |
Complete Recordset Object Reference
From http://www.w3schools.com (Copyright Refsnes Data)