Go To Control

[Ivor Williams]

I have a form frmProjects. On the form is an unbound combo box (cboProject)
used to select a Project. On the form there is also a tab control with a
number of pages, each with a subform linked to the frmProjects form.
After the value in cboProject on the main form is updated, I want the focus
to shift to combo box cboEmployee on the sfrTimeline subform on a tabbed
page. I need some help with referencing the various controls in VBA to make
this happen, please.

Ivor

 

[Ken Snell \(MVP\)]

To set focus to a control within a subform, you need to do two SetFocus
actions. The first sets focus on the subform control (the actual control
that holds the subform object on the main form); the second sets focus on
the control in the subform.

Me.NameOfSubformControl.SetFocus
Me.NameOfSubformControl.Form.NameOfControlInSubform.SetFocus