Using forms as a menu tree?

[ZBC]

I am rather new at Access (2000) and am thinking about using forms as a
menu tree (one main menu and several below it in a pyramid style tree).
Two questions:
1) Is this a good approach?
2) I believe I know how to call one form from another, but what is the
best way to go back up the tree? (assuming this is a good idea..)?

 

[Larry Linson]

That is the approach I use to creating Switchboards: unbound Forms with
Command Buttons, some of which may open another Switchboard Form, others of
which open a Form in the database application or a report.

DoCmd.OpenForm ... opens a Form. DoCmd.Close closes the current form/the one
in which the code is executing. I use those in the Click event of Command
Buttons to navigate the Switchboard structure.

I think it is a much better, simpler, and more straightforward approach than
the Switchboard Manager, which is IMNSHO "a complex solution to a simple
problem". We see enough questions in newsgroups about the Switchboard
Manager to convince me that my view is accurate.

Larry Linson
Microsoft Access MVP