You can specify what menu bar will be used with what form in the forms
"other" tab.
Just remember, that for about the last 10 years now, that office has used
the MIDI interface. that is what we call the multiple document interface.
That means that you have a menu bar across the top of the screen, and each
individual form in side uses that menu bar. So, each window in word, or in
Excel, or in ms-access do not have a menu placed on each form...but each
form can most certainly have a different menu. That menu is ALWAYS at the
top of the application. (this means the user does not have to hunt, or look
for a menu. The apple mac also works this way).
In addition to each form having a menu, you can create a custom menu for the
whole application. So, as a matter of the development process, you will
likely build a number of menu bars. One for the application..and then some
for forms that need a lot of options. Doing this can really clean up the
mess of buttons you typically see on the bottom of a ms-access form.
Here is some ideas as to why using menus in ms-access is a good idea:
http://www.attcanada.net/~kallal.msn/Articles/UseAbility/UserFriendly.htm
And, here is tutorial on making menus:
http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm