login form

[mujib ur rahman]

how to create code for login form when user select a administrator the separat form will be opene and when user select a operator the different form will be opende,,,,,,,,,,,,, plz any one help me its my last steps for completing database,,,,,,,,,,,,,,,

 

[Trevor G]

Attached find a sample database which has a staff table in it and based on the security level id (a number based on 1, 2, 3) when the database opens it will select the relevant form, it has a module sheet which has a case statement and also a autoexec macro which runs the code.

See if this will help you.

 

[MStef]

Look at "DemoLoginFormA2000.mdb" (attachment, zip).
Open Form1Login and see.

 

[mujib ur rahman]

sorry i dont know your suggestion i told u that i have two form one is booking and 2nd is adminform so from login if user are admin then open it adminform and if user are operator then opene it booking form,,,,,,,,, its my problem so plllllllz help me

 

[mujib ur rahman]

thanks alots to solve my problems but if easy method u know then plz help me,,,,,,

 

[smig]

if me.LoginName = "admin" than
docmd.OpenForm "AdminForm"
else
docmd.OpenForm "OtherForm"
end if
 
docmd.Close acForm, "LogInForm"

no need to shout BTW