Hi:

I need to create a very simple login screen for the program I'm working on. The users table has only 3 fields, user_id, name and password. Nothing futher is needed.

The login screen has two unbound boxes Name and Password. When the user enters their name (which is in the format of joesmith) and the password, they push the continue button. Which will run the code to first verify that the usernames name is in the table and if its there, then checks the validity of the password. If both are correct, it opens the form.

I'm using IF then Else statements,

If users name is correct Then
If password is correct Then
Open form
Else
Display message - Password Incorrect
End IF
Else
Display message - Name incorrect
End IF

I have the code for the message boxes and to open the form and they do work. I'm just having trouble figuring out how to take the entry from the unbound text entries and checking them against the table.

I need examples of the actual code. I'm not a programmer, but lately I have been.
Cheryl