User form to change log in password

[Ammarhm]

Hi Guys
I have attached with this post a logg in Access form that i found in this wonderful site which can be used as user name / passord control authentication before accessing a database
Now i need your wonderful help to creat a button in the switchboard that opens another form which allows the current (loged in) user to change his password.
How can this be done please??

 

[ajetrumpet]

Create the form you need, open the recordset, and update the field in the table that contains the current user's password. do you know how to use recordsets? Apparently, this database that you have open now does not contain references to them, or whatever you did (did you disable DAO objects in the database?)...

 

[Ammarhm]

Thank you for your answer
not really, i have nt disabled it....
I am a rather new beginner to acces,s i would appreciate if you could help me with the code for that please??

 

[Ammarhm]

Can anyone helph please with the VBA code ??