<%dim crumb crumb="DoCmd GotoControl" crumb1="Goto Control DoCmd" %> DoCmd GotoControl in Microsoft Access
Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Forums  Blockchain Tech  Contact  Privacy  Links

DoCmd Examples - Access VBA<%response.write "
" & crumb1 %>

Docmd Macro VBA Example
Developer Home > Access Database Tutorials > DoCmd Examples<% response.write " > " & crumb %>
<% dim Gnum,Ynum Gnum="3847865006" Ynum="7164" dim Page_Type Page_Type="Prog" %>

DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs


Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013

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:

Access Docmd GotoControl Method Example

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 with Goto Control

FindFirst Recordset with Goto Control Visual Basic

Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>