username&password

[metokushika]

hi everyone





i'm having problems on how to
make a simple form where i can
compare the username and passwords
from a table where the employee's
username and passwords are saved.


what i want to do is to make sure
that whatever username is typed in,
i want to match it to it's password


and of course if the password doesn't
match the username, the user can no longer
enter to the other form.



any help will do. thanks!

[June7]

Will need VBA code. In the AfterUpdate event for the password textbox, like:

If DLookup("Password","UserTable","UserID=" & Me.UserTextbox) = Me.PasswordTextbox Then
'code to continue
Else
MsgBox "Not authorized user, contact administrator"
EndIf