asked on

Access Switchboard fails to return to previous menu, but only if options were run in THAT menu?

I have a complex, "deep" switchboard (built-in that comes with Access) and on three of the submenus, the 'return to Previous menu" options work fine, as long as neither o the two report options on them are actually clicked on. They all three return to the calling menu, as they should.

However, if either of the two actual options are executed (macros which build and display a table plus build a spreadsheet from that table), THEN clicking the 'return to previous menu' no longer returns to the previous menu -- it doesn't "do" anything that is apparent.

The entire switchboard must be closed and reopened, in order to continue with the program.

Any ideas? Logically, it's something that goes on in the programs being executed . . . do you need more details of what they do?

Thanks,
Bill C

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

The only thing I can think of is ... some sort of error is occurring and not being seen, or masked in some way. This is way I don't use the switchboard, as it's generally hard to troubleshoot issues of this nature.

mx

bcreen

ASKER

Are there any superior 3rd party REPLACEMENTS for the ole Switchboard in Access? Maybe something that can optionally import a current switchboards properties and entries, etc.?

What do YOU use in it's place? just manually-coded forms?

Thanks for your response!
Bill C

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"What do YOU use in it's place? "
I've (easily) been creating my own custom menu, toolbars and popups for years.

Everything you need is here - no code ... see this link:

http://www.jamiessoftware.tk/articles/menubars.html

Not sure it that article mentions it, but ... when you are in the Customize mode (dialog) ... if you hold down the Control key, you can drop and drag (ie, copy) menu items from one place to another ... handy for making a new menu that is similar another one.

mx

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer