I don't know why this has been kicking my butt for so long, but I just cannot figure out how to get Password changes to work on a user level.
I have a form with 2 txt boxes to enter a new password and confirm it, these are named txt NewPassword and ConfirmPassword. I have code attached to the After Update field:
Code:
Private Sub ConfirmPassword_AfterUpdate()
If Me.NewPassword = Me.ConfirmPassword Then
MsgBox "Password updated!", vbOKOnly
DoCmd.Close acForm, "frmPasswordChange"
Else
MsgBox "Passwords don't match please re-enter!", vbOKOnly
Me.NewPassword.SetFocus
End If
End Sub
I cannot figure out, and I have tried many different things, how to get it to take the password they enter and put that in the tblEmployeeFiles table to update it. They reference their own record by Forms!frmLogin!cboUser.Column(0) which is linked to the EmployeeID on the tblEmployeeFiles table. The password field is UserPassword.
I have kind of put this on a backburner as it is only marginally important at the moment, but it has been driving me crazy I can't figure out what to put in