VBA code for form for password change

[Mainer]

I am an "advanced" Access user but just beginning to tackle actual VBA coding.
I have a users table with userID and Username and Password for those using a front end database
I have just made a form with a typical password change setup

UserID
Username
Old password
New password

I have a button on the login form that users see when successfully logged in

What code can I use so that the loggedin user can change the password ?

Thanks for any help

[pbaldy]

Here's one way:

  CurrentDb.Execute "UPDATE tblUsers SET UserPassword = '" & Me.txtCnfPW & "' " & _
                     "WHERE UserName='" & Me.txtUserID & "'"

[CJ_London]

also take a look at the bottom of this thread where the same question has been asked - I see 5 threads on the subject

[Mainer]

Thanks- I will check this out. Meantime can you explain Me.txtCnfPW ?
Fred

[mike60smart]

Hi Fred

Me.txtCnfPW is the reference to the Unbound Control named "txtCnfPW" on the Login Form

You would have to change this name to match the name you have given to your New Password Control.

[pbaldy]

And the same with txtUserID.