Creating a macro that will check password

[greggc]

To whomever can assist!!

I'am doing a class project that involves creating an alumni database. It begins with a form where the user type is broken down into alumni or student. If you are an alumni clicking the button will take you to a form were you must enter in your username and password before going to a new form that will allow you to update your information.

My problem is that i can not creat a macro that will do the following:
(1) check to see if the username typed in the text box can be found in the table that contains all of the usernames and passwords.
(2) then it should do the same thing but with the password.
(3) If a proper username and password is typed into the text box then the form titled faculty1 should open.
(4) if false values are enter then a message box should appear saying "invalid user"

I don't know much about macros so detailed and ordered instructions would be nice if possible!!

Chris

[NeoPa]

There are other threads in here which deal with the matter in more detail, but simply, you can do a DLookup on the table that contains your usernames and passwords passing the values to be checked. If it returns a record then the values are ok.
MsgBox() etc should handle the rest for you.

[greggc]

There are other threads in here which deal with the matter in more detail, but simply, you can do a DLookup on the table that contains your usernames and passwords passing the values to be checked. If it returns a record then the values are ok.
MsgBox() etc should handle the rest for you.

How do i perform a Dlookup.. im very new with macros

[NeoPa]

I suggest, for questions of that level, you should look it up in the help system.