security

[shadowraven]

I currently has a change password form which allows users to change there password, my problem is that on the form it is meant to display the username but I cant get it to display the currect persons user name thus it changes someone elses password causing chaos. pls help!!!!!!!!!!!

 

[Fizzio]

Shadow,

Try to email your Db to me. I know what the problem is (as I've seen your Db before, but cannot find it!) Essentially your code is checking the passwords in one table but changing them in another. The checking and changing should be to the same table. I've tried explaining this before but you have obviously not been able to get it to work. If the Db is not too big, you can add it as an attachment here (if you do not have easy access to e-mail)

 

[usachrisk]

Are you trying to get a form text box to display the username of the person who logged into access? If this is the case, you can use:

txtUserName = Application.UserName

Where txtUserName is the name of the textbox.

Christopher.

 

[Autoeng]

Or CurrentUser() will wrok.

Autoeng