DoCmd.AddMenu

Add a custom menu bar/shortcut bar.

Syntax
      DoCmd.AddMenu(MenuName, MenuMacroName, StatusBarText)

Key
   MenuName       The name of a drop-down menu to add to the
                  custom menu bar or global menu bar. (string)
                  To create an access key so that you can use the
                  keyboard to choose the menu, type an ampersand (&)
                  before the letter you want to be the access key.

   MenuMacroName  Name of the macro group that contains the macros
                  for the menu's commands. This is a required argument.

   StatusBarText  Text to display in the status bar when the menu is selected.

Use AddMenu action to create:

• A custom menu bar for a form or report. This will replace the built-in menu bar for the form or report.
• A custom shortcut menu for a form, form control, or report. This will replace the built-in shortcut menu for the form, form control, or report.
• A global menu bar. This will replace the built-in menu bar for all Microsoft Access windows, except where a custom menu bar for a form or report has been added.
• A global shortcut menu. This replaces the built-in shortcut menu for fields in table and query datasheets, forms in Form view, Datasheet view, and Print Preview, and reports in Print Preview, except where a custom shortcut menu for a form, form control, or report has been added.

menuname and menumacroname are required for custom menu bars and global menu bars.

The menuname argument is not required and will be ignored for custom shortcut menus and global shortcut menus.

The statusbartext argument is optional, this argument is ignored for custom shortcut menus and global shortcut menus.

Example

DoCmd.AddMenu, "CustomMenu1", mcrMenu1

“One of the main causes of the fall of the Roman Empire was that, lacking zero, they had no way to indicate successful termination of their C programs” ~ Robert Firt

Related:

.DoMenuItem (DoCmd) - Display a menu or toolbar command.
.RunCommand (DoCmd) - Run an Access menu or toolbar command.
SetMenuItem (DoCmd) - Set the state of menubar items (enabled /checked)