Do I have the correct and or up to date project. In the one you sent me Command1 has a cation of "Update" and the following code.


VB Code:
  1. Private Sub Command1_Click()
  2. On Error Resume Next
  3. With RS
  4.     If MsgBox("Update The Record?", vbQuestion + vbYesNo, "Confirm") = vbYes Then
  5.     .Fields("uname") = txtUser.Text
  6.     .Fields("pass") = txtPass.Text
  7.     .Update
  8.     .Requery
  9. MsgBox "The current record has been updated", vbInformation, "Update Successful"
  10. End If
  11. End With
  12. End Sub