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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximize Switchboard - Access 2007 3
Access 2010 DB not fuctional with multiple users 2
rwop works 2
Dymanic List Range 2
Switchboard 2
Open form if conditions are met 1
Refresh form while Open 6
Switchboard created with Switchboard Manager doesn't open 3

Top