GoToControl Method

Applies To DoCmd object.

Description

The GoToControl method carries out the GoToControl action in Visual Basic. For more information on how the action and its argument work, see the action topic.

Syntax

DoCmd.GoToControl controlname

The GoToControl method has the following argument.

Argument	Description

controlname	A string expression that's the name of a control on the active form or datasheet.

Remarks Use only the name of the control for the controlname argument, not the full syntax.

You can also use a variable declared as a Control data type for this argument.

Dim ctl As Control
Set ctl = Forms!Form1!Field3
DoCmd.GoToControl ctl.Name

You can also use the SetFocus method to move the focus to a control on a form or any of its subforms, or to a field in an open table, query, or form datasheet. This is the preferred method for moving the focus in Visual Basic, especially to controls on subforms and nested subforms, because you can use the full syntax to specify the control you want to move to.

See Also GoToControl action, GoToPage method (DoCmd object), GoToRecord method, SelectObject method, SetFocus method.

Example

The following example uses the GoToControl method to move the focus to the EmployeeID field:

DoCmd.GoToControl "EmployeeID"