Edit table entry in VB though form

[amraam35]

Hey, thanks for any help in advance,

I have a table with three fields. User ID, User Name, and Password.

I have a form called "ChangePassword", where you can change the old password into a new one. You enter the User Name and password, and a then a new password that you want to change the old one into. If the user name and old password match, then the program continues and allows you to change passwords.

It works up to there. I cannot figure out how to get the visual basic to take the "old password" from the table, and replace it with the "New password" which was entered in the form, but has yet to be saved to a table or anything. I dont want to replace the username or ID, just swap passwords.

Is there a function that will do this?

say, declare the table password,

then declare the form entry (new password),

then replace the table password value with the new password value?

thanks for any help

 

[PHV]

Have a look at UPDATE query and the DoCmd.RunSQL method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886