login Form

[showri]

I am designing a form which takes input form the keyboard and when the user pressess enter , based on the input the particular form opens up.

The project is a student, teacher and a tutor database:

when a student enters the id a student form will open up. the id starts with 00
when a teachers enters the id a teacher form will open, the id starts with A and Username somethin like this :Ateach , I have a tabe which stores the id of teachers and when it matches the id it will ask for password and then shows up the form
when a tutor enters the id a tutor form should open up, the ID starts with T like Ttutor , the same set of criteria of teacher applies for tutor.

Can anyone help me how do i pick up the ID and bring up the appropriate form, I do have all the forms built, two tables to verify access privilegaes once for teacher and on for tutor.

 

[Vassago]

I am designing a form which takes input form the keyboard and when the user pressess enter , based on the input the particular form opens up.

The project is a student, teacher and a tutor database:

when a student enters the id a student form will open up. the id starts with 00
when a teachers enters the id a teacher form will open, the id starts with A and Username somethin like this :Ateach , I have a tabe which stores the id of teachers and when it matches the id it will ask for password and then shows up the form
when a tutor enters the id a tutor form should open up, the ID starts with T like Ttutor , the same set of criteria of teacher applies for tutor.

Can anyone help me how do i pick up the ID and bring up the appropriate form, I do have all the forms built, two tables to verify access privilegaes once for teacher and on for tutor.

I assume you have a button on this login form that they must click that would pull up the appropriate form. In this case, some vba behind this button onclick will do the trick based on the ID that is entered.

Something like:

If left(ID,1) = "T" then
DoCmd.OpenForm "Tutor"
ElseIf left(ID,1) = "A" then
DoCmd.OpenForm "Teacher"
Else
Docmd.OpenForm "Student"
End if

Play around with that idea for a while.