switchboard based on userid

A

Andrew Peterson

Is it possible to have a switchboard or "main" form that
opens, based on userid?

i.e.
user1 logs into db and sees form1
user2 logs into db and sees form2
admin logs into db and sees admin_form

TIA
 
A

Adrian Jansen

Have a hidden form set to open when the database opens. In the form open
event ( untested code ) :

Select Case CurrentUser()
Case User1
Docmd.openform Form1
Case User2
Docmd.openform Form2
Case Admin
Docmd.openform Admin_Form
End Select

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Top