Multiple Switchboards?

[Cosmos75]

Can I have multiple switchboards? I want the main switchboard to look a certain way. In the main switchboard I have aswitchboard that opens forms and another that opens reports, and I would like to have the forms reports look different than the main switchbaord, ditto for the reports switchboard? How do I do that? I don't know anything about writing code or events for switchboards, only how to use the switchboard manager.

THANKS in advance!!

 

[Travis]

A switchboard is just another form created by the Wizard. Just Create other switchboards and launch them from the Main Switchboard.

 

[vangogh228]

True. But... avoid the mistake I made several times until I wised up. Be sure to put a "Back to Main Switchboard" item on each of the other switchboards.

 

[Cosmos75]

Got it, One question, though.

With Multiple Forms as Mutiple Switchboards, is there a way I can get it to close the active Form (switchboard) when I choose to open another Form (switchboard)? If not, it is possible to have a few forms open before getting to the one I want.

Am fairly new to Access so please bear with me!

THANKS!

 

[spalmateer]

Hi,
I recommend that you make your own Switchboards vs using the Switchboard manager. You have more control over the design and more flexbilitity doing it that way.
To close the last form when you open a new one. Have the wizard make the button for you that takes you to the new form. Then you have to right click on the button and go to properties--->Events Tab--->On Click. Then click the ... on the right and choose code builder. Then you'll see some code that the wizard made. Right after the:

DoCmd.OpenForm stDocName

put in this code

DoCmd.Close acForm, "yourformnamethatyouwanttoclose",acSaveYes' Or acSaveNo if you don't want to save the form.

Then that closes the last form after the new form opens.
HTH,
Scott