Show All

RunCommand Method

The RunCommand method runs a built-in menu or toolbar command.

expression   Required. An expression that returns one of the objects in the Applies To list.

Command  Required AcCommand. An intrinsic constant that specifies which built-in menu or toolbar command is to be run.

Remarks

Each menu and toolbar command in Microsoft Access has an associated constant that you can use with the RunCommand method to run that command from Visual Basic.

You can't use the RunCommand method to run a command on a custom menu or toolbar. You can only use it with built-in menus and toolbars.

The RunCommand method replaces the DoMenuItem method of the DoCmd object.

Example

The following example uses the RunCommand method to open the Options dialog box (Tools menu).

Public Function OpenOptionsDialog() As Boolean

On Error GoTo Error_OpenOptionsDialog

    DoCmd.RunCommand acCmdOptions
    OpenOptionsDialog = True

Exit_OpenOptionsDialog:
    Exit Function

Error_OpenOptionsDialog:
    MsgBox Err & ": " & Err.Description
    OpenOptionsDialog = False
    Resume Exit_OpenOptionsDialog

End Function