entering data into a table using a record field

[Jaymin]

Hi,
Hope i can explain what i want to do ,I might be just having a seniors moment.
I am creating a log in form, it checks the user name which is unique. if the user has entered a password, it shows only one password text box, they enter the password, if it is correct they enter the database, otherwise they return to the text box.
But if they have not entered a password before the form opens with two text boxes, one for the password and one to confirm the password is typed correct,
if the are different a message box shows telling them that they are different,
now is where i having problems, when they have typed the two passwords and they are correct i want them to save this password in the same record "Password" as the selected "username" record, I can find the "username" record by doing a Dlookup, easy, but i am stuck how to then save the password from the text box where the selected username record is.
my table "staff" has fields of "IDStaff", "FirstName", "Surname", "Password", "Username".
Hope this makes some sense :banghead:

 

[JHB]

Use an update query, (or a recordset)!

 

[Jaymin]

JBH,
thank you for your reply, with a bit of research and playing around i got the recordset to work just fine.
thanks foryour time and help
Peter

 

[JHB]

You're welcome, luck with your project.