Thanks Eric for your help with this, having trouble though maybe you can help.
I create a Users_Update page by creating a recordset which filters on session variable = UserID
When i add in the update record it updates all the information correctly. I then added the encryption SHA1 onto the text fields "Password and Confirm Password" boxes i created well what i thought i had done however it was not that, it was in the bindings panel of my recordset that it changed it to encryption SHA1. Not sure if this is the right way to do it Eric, as it encrypts the value that is currently in the box but when i insert a new password it goes into the database the way i key it in. How should it store the password in the database, encrypted or not? How do i add it to encrypt the password when updated and inserted and not the actual value that i have in the update page?
Thanks eric again for your help and sorry if this is a simple fix.