Login Form Help! 07'

[JBurlison]

Still trying to learn VB i cant get my Login to work.

The table i have my user names and passwords stored on is called "User Name"

The user name column is "User Name" and the Password is "password"

The Login Form Name is "Login Screen" one drop down box with the user names in it named "User Names". another empty text Box Named "password"

my VB code for the login button as follows:

If [Password] = [User Names]![Password] Then
DoCmd.OpenForm "Switchboard"
DoCmd.Close acForm, "Login Screen"

Else

MsgBox ("Incorrect password")
[Password] = ""

End If

I know there is a way to have a specific number of logins cant remember the code for that ether.

i know the statement is wrong, do i have to set focus's or something?
Please HELP!

 

[oxicottin]

Here is a site that has a working example among other great examples! Hope this helps.

 

[JBurlison]

The Code Here is Good but i dont quite understand it what dose the Me.XXXX function do?
also i think some of the functions might be laid out a little differently now any advice to updating this to 07'