Update Particular Record

[anwaar]

I have two controls on Access Form, one is combobox which have all usernames and second a textbox contains passwords. Now I locate password in textbox through"Private Sub username_Change()" event procedure. Password located successfully.



Now the problem is if I update password of that particular username (located through above procedure) using button and code

Private Sub UpdatePassword_Click()
DoCmd.RunCommand acCmdSaveRecord
End Sub

It update first record of the table where username and passwords are saved instead of the password of that particular username (located earlier).

Please help me to resolve this problem.

[pbaldy]

It would probably help to see your other code. The code you posted will save whatever record is displayed on the form, which doesn't sound like what you want.