DAO update field

Hi Gillian

Thanks for the question.

DAO will do what you want to do I think. Below is a simple example of walking through a complete table updating a field.

Sub EditRow_DAO()

    Dim DB As DAO.Database

    Dim tblItems As DAO.Recordset

    'get the current database and recordset to work with

    Set DB = CurrentDb

    Set tblItems = DB.OpenRecordset("tbl_Items")

Do Until tblItems.EOF

tblItems.Fields("TrimmedName") = Trim(tblItems.Fields("OriginalName"))

tblItems.Update

tblItems.MoveNext

Loop



    'close the recordset and database

    tblItems.Close

    DB.Close

End Sub