switchboard based on userid

  • Thread starter Thread starter Andrew Peterson
  • Start date Start date
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
 
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
 
Back
Top