[RESOLVED] Updating database --- not new record ----

[graphixphantix]

I've finally gotten everything working great the textboxes ,the comboboxes , the database etc I am using ADO code but was has me stuck is this....I can view my data but when I make changes and press my update button my message box pops up, I go to the next record but when I comeback, no changes were saved. I changed to adlockOptimistic. This is the code I'm using to udate changes to a record.

Private Sub cmdUpdate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

rs.Update
MsgBox "Student information updated.", vbExclamation

End Sub

What am I doing wrong??

[RobDog888]

Are you using the ADODC Data control or are you manually coding all your rs code?

[graphixphantix]

I am manually coding rs.

[RobDog888]

Then you need to tell it which fields to update.

rs.Fields("Field1").Value = "Something"
rs.Update

[dee-u]

I've finally gotten everything working great the textboxes ,the comboboxes , the database etc I am using ADO code but was has me stuck is this....I can view my data but when I make changes and press my update button my message box pops up, I go to the next record but when I comeback, no changes were saved. I changed to adlockOptimistic. This is the code I'm using to udate changes to a record.

Private Sub cmdUpdate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

rs.Update
MsgBox "Student information updated.", vbExclamation

End Sub

What am I doing wrong??

Why don't you use the Click event?