Passsword confimation

[daveee143]

I've write a code in access using vb to verify that when a user input a record to password 2 it must confirm the same as password 1, but the problem is when i input a password in password 1, then click password 2 there already a password which is not the logical idea of writing a new password.

Here the code

If Me.Password2 = Me.Password Then
DoCmd.Close acForm, "NewUsers", acSaveYes
DoCmd.OpenForm "Login"
Else
MsgBox "Invalid Password", vbOKOnly, "Retype Password"
Me.Password2.SetFocus
End If

just like creating a new account. gusy help me in here.