Hi

I need help with a custom login screen. The following tables and fields are
what I have to work with;

Table              Field

Staff Info        SN (Staff Number) (Primary Key)
                     Name
                     Int
                     First

Account Info  SN
                     UserID
                     Password

I have created four forms "Login", "Add Staff", "Wardroom" and "Account
Info". The Add Staff & Account Info are for inputting new staff only. What I
need to do is have the "Login" command button verify the userid and password
from the "Account Info" and if successful it will then open a form called
Wardroom and to that staff's record

The Wardroom form has several subforms which allows them to input
information only into their records

Any help is appreciate!
Wes