Call update method from Recordset : Recordset Add Update Delete « Access « VBA / Excel / Access / Word

Call update method from Recordset

Public Sub ADOUpdate()
  Dim rs As ADODB.Recordset
  Dim strSQL As String
  Set rs = New ADODB.Recordset
  strSQL = "SELECT CompanyName, Address, City FROM tblCompany WHERE (CompanyName = 'Liams Diner')"
  rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
  With rs
    !CompanyName = "Diner"
  End With
End Sub


Related examples in the same category

1.Add new a row to recordset
2.Adding a New Record to a Recordset
3.Use AddNew and specify the field information
4.Use AddNew method from Recordset and two arrays to add a new row
5.Adding a New Record to a Table
6.Modifying a Record
7.Performing Batch Updates
8.Delete row for a certain criteria
9.Deleting a Record
10.Call delete method in Recordset
11.Check the Recordset affected