The Switchboard Manager in MS-Access is a
handy tool that provides for quick-and-dirty menu creation to organize the work
flow. To help users visualize & understand the navigation, I created a form
with a Treeview control, call it Treeview1.
Note: The narrow display format in this weblog mangled the line breaks, so I've moved this article and code to this URL (you can just click on the title of this article):
When you review the code, keep in mind that I have an item "GO BACK" on each switchboard page that takes the user back to the previous page.
Simply create a form, add a Treeview control and invoke the code from the Form_Load event. I also add a Form_Activate event to DoCmd.Restore so the helper form always displays in a reduced window.