Hi Pat.

Is there an easy way to delete and add a record to a RS?

To add a record to the RecordSet, use the AddNew() method. This method accepts two parameters:

FieldList: an array containing the names of the fields to be populated
Values: an array of values for the fields in the FieldList array

The field values can be populated individually like this:

oRs.AddNew()
oRs.Fields( "Cust_ID" ).Value = "DEWEY"
oRs.Fields( "Company" ).Value = "Dewey Cheetum and Howe"
oRs.Fields( "Contact" ).Value = "Seymour Cash"

or you can create two arrays, one with the field names and one with the field values (in the correct order!) and pass these arrays as arguments to the AddNew() method like this:

oRs.AddNew( laFields, laValues )

To delete a record from the RecordSet, just use its Delete() method:

oRs.Delete()