Retrieve & Validate Data on 2nd Form based on Record Selected on 1st Form

[apinshot]

Can I look up and verify data on a “second” form based on a selected record from first (still open) form.

I’m trying to allow users to select a User Name from a combo box list and then open a “Change Password” form when they select “Change Password” for that selected user name.

My problem is that I can’t figure out how to associate and verify the data tied to the user name selected on the previous (Login) form –( I’m trying to validate the old password tied to that selected record).

I have the first login form created, and it’s working just fine. I also have the change password form created (and it’s displaying the user name selected from the first form – using:​

Private Sub Form_Load()
 With Forms![frmLogin]![cboUserName]
   Me.txtPwdChgUserID = .Column(2, .ListIndex)
  End With
EndSub

I also have the code written to validate and confirm old password, new password and validate new password (when the save button is clicked). I have yet to update the password with the new password (still trying to figure that out).

My VBA skills are very limited - I'm trying to learn.

Attached zip file has screen shots of the two forms.

Any help would be appreciated. I can send more details if needed. Thank you.
​

 

[JHB]

Use an update query.

 

[apinshot]

I figured I have to use an UPDATE statement to replace the current password with the new password.

An UPDATE statement though won't solve my first issue.

 

[JHB]

I figured I have to use an UPDATE statement to replace the current password with the new password.

An UPDATE statement though won't solve my first issue.

I must be missing something, what is the first issue and what is the problem with it?