DoCmd Object
You can use the methods of the DoCmd object to run Microsoft Access actions from Visual Basic. An action performs tasks such as closing windows, opening forms, and setting the value of controls.
Using the DoCmd Object
For example, you can use the OpenForm method of the DoCmd object to open a form, or use the Hourglass method to change the mouse pointer to an hourglass icon.
Most of the methods of the DoCmd object have arguments
DoCmd.OpenForm "Employees", , ,"[Title] = 'Sales Representative'"
The DoCmd object doesn't support methods corresponding to the following actions:
- AddMenu.
- MsgBox. Use the MsgBox function.
- RunApp. Use the Shell function to run another application.
- RunCode. Run the function directly in Visual Basic.
- SendKeys. Use the SendKeys statement.
- SetValue. Set the value directly in Visual Basic.
- StopAllMacros.
- StopMacro.
For more information on the Microsoft Access action corresponding to a DoCmd method, search the Help index for the name of the action.
The following example opens a form in Form view and moves to a new record.
Sub ShowNewRecord()
DoCmd.OpenForm "Employees", acNormal
DoCmd.GoToRecord , , acNewRec
End Sub