Table of contents
Collapse the table of content
Expand the table of content

Add a Record to a DAO Recordset

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

You can add a new record to a table-type or dynaset-type Recordset object by using the AddNew method.

To add a record to a table-type or dynaset-type Recordset object:

  1. Use the AddNew method to create a record you can edit.

  2. Assign values to each of the record's fields.

  3. Use the Update method to save the new record.

The following code example adds a record to a table-type Recordset called Shippers.

Dim dbsNorthwind As DAO.Database 
Dim rstShippers As DAO.Recordset 

   Set dbsNorthwind = CurrentDb 
   Set rstShippers = dbsNorthwind.OpenRecordset("Shippers") 

   rstShippers!CompanyName = "Global Parcel Service" 
      . ' Set remaining fields. 


When you use the AddNew method, the Access database engine prepares a new, blank record and makes it the current record. When you use the Update method to save the new record, the record that was current before you used the AddNew method becomes the current record again. The new record's position in the Recordset depends on whether you added the record to a dynaset-type or a table-type Recordset object. If you add a record to a dynaset-type Recordset, the new record appears at the end of the Recordset, no matter how the Recordset is sorted. To force the new record to appear in its properly sorted position, you can either use the Requery method or recreate the Recordset object. If you add a record to a table-type Recordset, the record appears positioned according to the current index, or at the end of the table if there is no current index. Because the Access databse engine allows multiple users to create records in a table simultaneously, your record may not appear at the end of the Recordset. Be sure to use the LastModified property rather than the MoveLast method to move to the record you just added.

Note If you use the AddNew method to add a record, and then move to another record or close the Recordset object without first using the Update method, your changes are lost without warning. For example, omitting the Update method from the preceding example results in no changes being made to the Shippers table.

© 2018 Microsoft