Selecting different switchboards with a macro or running a macro when

[BrentJ]

I have a central database with everyone in the company. I have all my forms and reports setup to be filtered by sections but I would have to have a switchboard button for every instance of every form and report (which would be a huge mess of switchboards!) I want to have the main switchboard select the section to filter by and then go to switchboards for the forms and reports. I could not find a way to execute a macro (to set the section) and change switchboards with the same button and I'm not sure how to have a macro change switchboards (only to open or close the switchboard form). The way that I have it setup now is to run a macro that opens a hidden form and sets the value of a text box on that form to the corresponding section. I can then reference that text box for the value to apply to the filter (I would welcome any suggestions if anyone knows an easier way to do this, but this method works for what I am trying to do with the exception of being able to run the macro and change switchboards). Any ideas? Thanks.

 

[SiJP]

I'd suggest using the switchboard manager to do all this for you...

Tools.. Add Ins.. Switchboard Manager

------------------------
Hit any User to continue

 

[BrentJ]

I did use the switchboard manager to setup the switchboards. The problem is that when a section is selected from the main switchboard I can either have it run a macro or go to another switchboard. I need it to do both. Either run a macro to set the section and have the macro change the switchboard or change the switchboard and have it run a macro upon loading the new switchboard page (based on the switchboard page that was loaded).

Thanks.