Hi, I have a form in my project and what it does is change the passwords in the database for users. Firstly, at the top of the form is a DBCombo box (DBAccounts) which lets the user select there username. Second is a text box(TxtPword(0).text) that the user is asked to enter in there current password. The 3rd (TxtPword(1).text)and 4th textbox(TxtPword(2).text) is for the new password they wish to input. The third and 4th textbox must equal each other before the user can update his/her password (like a verification check). Now my problem is I can't get txtpword(0).text which is the password from the database to match the user in the DBCombo box. I can get the user's names up in the DBCombo box. Now here is the code I am using to update the user's password :

Private Sub UpdatePassword()

Dim Ans As String, mRrstrans As Recordset

DatAccounts.Recordset.FindFirst ("PassID = " & DBCAccounts.BoundText)

Set mRstrans = pDatabase.OpenRecordset("Password", dbOpenTable)

If TxtPword(0).Text = mRstrans!Password And TxtPword(1).Text = TxtPword(2).Text Then

mRstrans.Edit

fldname = "Password"
mRstrans.Fields(fldname).ValidateOnSet = True
mRstrans.Fields(fldname) = TxtPword(1).Text

mRstrans.Update

mRstrans.Bookmark = mRstrans.LastModified

fp.Refresh = True

Unload Me
Ans = MsgBox("Your Password Has Been Updated", vbInformation)
mRstrans.Close

Exit Sub

Else
Ans = MsgBox("Please re-type your Old and/or New Password as they don't Match.", vbCritical)

End If

End Sub

Okay, now when the user is selected with DatAccounts.Recordset.FindFirst etc it shows the primary key. My main problem is where it says mrstrans!password it only looks at the first record and uses that password. How do i change this code to make the DBCombo box and txtPword(0).text compare each other when a user is selected. This code is under a function and is called when the ok button is click after the user has entered in the old and new passwords. Any hel would be much appreciated. Thanx in advance.

Mike