Change Password Form. (1 Viewer)

[accessaspire219]

Hi,
I have a change password form on which there are 4 text boxes and a button.
Text Box1= login name (windows username of the user picked up automatically)
Text Box2=oldpassword (user enters the old password)
Text Box3=newpassword (user enters the new password)
Text Box 4=newpassword1 (user re-enters the new password)
I need help with the part of the code that will do the following.
If the old password entered in text box 2 matches the old password stored in the UserInformation table for the login name in text box 1
On clicking the change password button replace the oldpassword (under the password column) in the User information table with the newpassword. Save table and close form.
Else, give an error message that the user entered an invalid password.
Italics indicate the part of the code that I am unable to write.
Thanks!

 

[pbaldy]

Either open a recordset with an SQL statement that returns that user, and use the Edit method to change the value, or execute an UPDATE query that updates that user.