changing table info with a button

[Rudeman76]

I have a table with 3 columns. A crew column (user name), a password column, and an admin column (yes/no). I have made a form so the user enters in a user (which is stored in a public string) and password to get to the main form. I have made a form so the user can change the password if they want. I have it so they enter in the original password followed by the new password twice and press an update button. I open up the recordset and it finds the user and and compare the original password. This works great, my problem is when i go to update the table with their new password, it doesnt update. my error checking says it is updated but when i check the table, its still the same. this is the code i used. rspass!Password = txtnewPassword.value
rspass.update.

 

[boblarson]

The simplest way is to just create an update query that gets its parameters from the password form and run it.

 

[Rudeman76]

not sure how

I am still very new to Access. I am not very good at queries and do not know how to do the one you recommended. If you could help or send me to a link to help me understand them more that would be great. Thank you for all your help up til now, its been very helpful.