Set default switchboard based on network user ID

[vandaliarental]

I've used the Switchboard Manager to create several different switchboard for different users. I also have the code to pull their network user ID & using a Dlookup, find which switchboard should load when they open the database. The database is set up to load a default switchboard upon opening.

How do I change which switchboard actually loads on opening?

Thanks,
Connie
Vandalia Rental

 

[PHV]

Use your default switchboard as a wrapper playing with the DoCmd.OpenForm method depending on the network user ID.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vandaliarental]

PH:

That's the line of thinking I was following, but I need a little more info.

str = "Leader Menu"
docmd.openform "Switchboard", acviewnormal

Where do I put that str value? 'Leader Menu' is the name of the menu I created with the switchboard editor. The default menu is set to 'Main Menu'

Thanks,
Connie
Vandalia Rental