Hi Rick,

Is it possible to move multiple rows of a table to another table with a recordset?  When i try it, it only moves over one record.

the recordset is set up to move the info and it works but only moves the first unit (piece of equipment) instead of the entire list.  do i need to do a loop?

    Dim db As Database
    Dim rs As Recordset
    
    Set db = CurrentDb()
    Set rs = db.OpenRecordset("POL_EquipmentList_tbl", dbOpenDynaset)
    
    rs.AddNew
    
    rs.PolicyNumber = NewPolicyNumber
    rs.EffectiveDate = RENEWAL
    rs.UnitStatus = UnitStatus
    rs.UnitYear = UnitYear
    rs.UnitMake = UnitMake
    rs.UnitType = UnitType
    rs.UnitKind = UnitKind
    rs.UnitVin = UnitVin
    rs.UnitValue = UnitValue
    rs.UnitRadius = UnitRadius
      
    rs.Update
    rs.Close
        
    Set rs = Nothing
    Set db = Nothing

---

Reply from Richard Rost:

Yes. If you have more than one record, you DEFINITELY need a loop AND you'll need TWO recordsets... one for input (read) and another for output (write).

It MIGHT be easier to do this with an APPEND query followed by a DELETE query.