Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

DoCmd Examples - Access VBA
Goto Control DoCmd

Docmd Macro VBA Example






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



A Blue Claw Software Design Template:

Contact Management Application
 










A Blue Claw Database Design Article:

Access Form Design Help
 









Blue Claw Database Design Downloadable Tutorial:
Access Report Banding  



Contact Information

Copyright 2000-2017 Blue Claw Database Design