Docmd GotoControl Access Example

The DoCmd GoToControl method moves the cursor (sets focus to) a field or control on a form in VBA.

The control name is the only option available for the Goto Control statement:

ControlName: The name of a field or a control where you desire the focus to go. The control name can be a string expression, ie., "OK_Button", as in the visual basic example above, or it can be a variable which contains the name of a control on the form - note: no spaces are allowed in the name.

Consider using the Setfocus command in place of the DoCmd.GotoControl command because the set focus command has increased functionality.

Note that you may employ the GoTo Control method to move to a subform, which is a type of control. You can then use the GoToRecord method to move to a specific record in the subform. You can also move to a control on a subform by using the GoToControl action to move first to the subform and secondly to a control within subform.

More GotoControl Examples:

NotInList Event in Microsoft Access

GoToControl "acct_name_entry" GoTo exit_it End If ' add acct DoCmd.OpenForm ("f_accts_add") Form_F_accts_Add.acct_Name = newdata Me.acct_Name_Entry = Null ...
www.blueclaw-db.com/access_notinlist_advanced_example.htm

FindFirst Recordset Visual Basic

GoToControl "Find_Combo" End Sub. Below is a short cut method which accomplishes the same Visual Basic findfirst function: ...
www.blueclaw-db.com/access_findfirst.htm