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.