Originally posted by Bruce Fox
When updating values in a Row of a Recodset, which is the 'correct' option:
VB Code:
  1. rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

  2.  
  3.             With rs

  4.                 .Update "Project_Title", cboProject_Title.Value

  5.                 .Update "Date_Entered", txtDate_Entered.Value

  6.                 .Update "Title", txtTitle.Value

  7.             End With

  8.  
  9.         rs.Update

  10.  
  11.     rs.Close
Or
VB Code:
  1. rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

  2.  
  3.             With rs

  4.                 .Fields("Project_Title") = cboProject_Title.Value

  5.                 .Fields("Date_Entered") = txtDate_Entered.Value

  6.                 .Fields("Title") = txtTitle.Value

  7.             End With

  8.  
  9.         rs.Update

  10.  
  11.     rs.Close


Cheers,
Bruce.
I would also like to know.

I use :
VB Code:
  1. With rs

  2.     !Project_Title = cboProject_Title.Value

  3.     !Date_Entered = txtDate_Entered.Value

  4.     !Title = txtTitle.Value

  5. End With
Anything wrong with that?