i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE.
the first table contains (username, password, first name, last name).
the second table is only one field (manager, admin, agent).
there are two forms (administration, login), the administration form adds a new user, the login form makes user log in to the system.
the code is working perfectly, but i`m just missing something, i need a code that checks if the user is admin, agent, or manager. then according to the selection a msgbox appears "hi admin", "hi manager", "hi agent".

i attached the code, the login screen, the admin screen.
thanks in advance.