OK tblSupervisor has lngUserID PK - StaffName text - strUserPass - text
I have a log on form where a cmdbtn gives the user an option to update their password. (After logging in) This opens a frmUserPassword which has 4 unbound controls,
1 : PW_lngUserID which is populated by vba from the LogOn form (same as lngUserID)
2 : PW_LoggedOn which is the StaffName " "
3 : PassOne User Enters New password
4 : PassTwo User confirms New Password
and a Confirm Button which I am trying to update tblSupervisor[strUserPass with the new password by using an update query
using criteria [Forms]![frmUserPassword]![PW_lngUserID] and [Forms]![frmUserPassword]![PassTwo] as the Update for strUserPass
as well as other attempts but I'm starting to mutter and it is time to ask for suggestions as I could be heading the wrong direction