Hello all, i have a school project and i would like to create a login method that uses the user name and a password that are on the same record in a table how could i go about doing this?

for example

Record1: john l johns password
Record2: sarah l sarahs password
Record3: joe l joes password



i want to make it so when they enter a name into a textbox on a form, they must enter the correct password for that user name.

im using office (access) 2007 and know a little bit about vba and SQL but not a great deal so code or how-to would be helpful


Thanks