Opening Access switchboard

[Skip Bisconer]

I am using a Access generated switchboard in 2007 and would like to know if anyone knows how to get me back to the switchboard I was using when I closed the main switchboard and opened another user form? I seem to be only able to get back to the main switchboard on the close event of the userform that opened. I have tried minimizing the switchboard which sort of works but when it's called to open it maximizes and I need it to come back to it's restored version. Maybe someone has a better way to do what I want than I am currently thinking about. Thanks for looking at my problem.

 

[ajetrumpet]

so you close the main SB and open it back up later? is that all? And it opens in Maximized view?

what do you mean "get me back to the switchboard I was using"?? Do you have more than one?

 

[gemma-the-husky]

the access generated switchboard DOESNT automatically close when you open a form - have you edited to make it close?

 

[Skip Bisconer]

Thanks for responding,

On my main SB I have four other switchboards (pages) that take me to different proceedures Like Update Tables, Assign Orders, Reports, Table Maintenance. When I run, for instances, Reports for different departments I click the Reports button on the Main SB and select one of several reports for different departments.

I currently, through code, on the objects Load event, minimize the Switchboard form and open the report form. Then on the close event of the object, I restore the switchboard. I want to come back to the same Report screen, in this instance, instead it goes back to the main SB. I am using reports as an example, I have other processes that open forms to achieve different processes.

 

[ajetrumpet]

I currently, through code, on the objects Load event, minimize the Switchboard form and open the report form. Then on the close event of the object, I restore the switchboard. I want to come back to the same Report screen, in this instance, instead it goes back to the main SB.

what you just said sounds like that is exactly what is supposed to happen.

If you restore the switchboard on the "report" form's close event, it's already begun closing. Is that the form you want to go back to? If so, don't use a close event - the form is already closed!

If I'm wrong here, I'm not following...can you provide more detail?

 

[Skip Bisconer]

Adam, I think you are correct. I just looked at my code and I am closing the SB instead of minimizing. When I minimize and restore it comes back to the same form. Thanks for helping me think straight.

 

[ajetrumpet]

sure...

 

[gemma-the-husky]

just a note - with switchboards, make sure you always have an option 1 on each page - the code for the switchboard doesnt like it if there isnt an option 1