Changing Password using forms without userlevel security

[Newbie]

hi all,

i am doing a project which requires me to provide a security login
feature.
i understand that access has a user level security feature but i could
not use it coz i'm tested on my ability to use existing controls.

i did the login form, then it occured to me that it would be much more
convenient for users to change passwords themselves without needing the
administrator to change for them.

So, i created another form containing the following:

txtusername
txtOldPw
txtNewPw
txtconfirmPw

and a command button, cmdChangePW

on the click event of the command button, i ran a macro which did the
following:

1) check textboxes are null
2) check passwords are correct
3) run 3 SQLs

SQLs are like this [Do note that there are 3 tables containing 3
different userIDs and passwords to provide for different permissions
for different users]

UPDATE tblPasswordRece ivi
SET tblPasswordRece ivi.Password = '" & txtConfirmPW & "' WHERE
tblPasswordRece ivi.UserID ='" & txtusername & "'";

UPDATE tblPasswordPurc hase
SET tblPasswordPurc hase.Password=' " & txtConfirmPW & "' WHERE
tblPasswordPurc hase.UserID ='" & txtusername & "'";

UPDATE tblPasswordMgmt
SET tblPasswordMgmt .Password='" & txtConfirmPW & "' WHERE
tblPasswordMgmt .UserID ='" & txtusername & "'";

---------------------------------------------------------------------------------------------------------------------------------------

the problem i have is that the new password does not update itself to
the respective table..is something wrong here? i am still a newbie with
access (i just learned it at the end of last year), and realli not very
sure how to do modules esp. Can i do without modules and just stick
with macros?

To all ya kind souls, i thank you..i realli appreciate it!