Turn a form into a switchboard

[Digby]

I have made two main menus, one for admin and one for users, I want to turn these into switchboards. When you open a form asking you to log in opens if you supply the right password it opens another form depending on your access rights depends which menu it opens, it all works perfectly but I want a home button, i.e. close all open forms, which would close the main menu, so I need to turn the main menus into switchboards, I have tried searching this place and I have also tried google although I may aswell have stuck my head out an open window and shouted for help!

Any way any help much appreciated
Regards

 

[ColinEssex]

I can understand the logic for 2 menus.

Its easier to have the UserName checked on a UserName table and then include / hide the buttons on the normal switchboard according to their status.

Having got the users status, you can then apply this to the input form to lock it or allow edits / delete / addNew / hide fields or whatever you want.

Col

 

[Digby]

On the admin menu all the forms are tabular as this is how admin want to vies data whereas all the forms on user menu are tabular, I could turn the user main menu into a switchboard and then have a button "admin" which opens the admin menu, this could work, how do I go about either hiding the admin button from "users" or not allowing them to do it? Can I use an If statement ie

If Access Level = Admin Then
DoCmd.Open (Admin Main Menu)

ElseIf Access Level = User Then
DoCmd.Run Macro (saying they do not have access)

I think this will work I will try it, can i create my own message box that appears saying you do not have correct access rights?

Cheers, Also how do I make my main menu a Switchboard? or do I have to make a new one? I like my curent one!

 

[Digby]

So can any one tell me how to turn my frmMainMenu into a switchboard?

Cheers