Access Switchboard fails to return to previous menu, but only if options were run in THAT menu?
Posted on 2010-11-15
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?