.Update Method

[tpfkanep]

Originally posted by Bruce Fox
When updating values in a Row of a Recodset, which is the 'correct' option:

rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
 
            With rs
                .Update "Project_Title", cboProject_Title.Value
                .Update "Date_Entered", txtDate_Entered.Value
                .Update "Title", txtTitle.Value
            End With
 
        rs.Update
 
    rs.Close

Or

rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
 
            With rs
                .Fields("Project_Title") = cboProject_Title.Value
                .Fields("Date_Entered") = txtDate_Entered.Value
                .Fields("Title") = txtTitle.Value
            End With
 
        rs.Update
 
    rs.Close

Cheers,
Bruce.

I would also like to know.

I use :

With rs
    !Project_Title = cboProject_Title.Value
    !Date_Entered = txtDate_Entered.Value
    !Title = txtTitle.Value
End With

Anything wrong with that?