Reference controls on a subform

[Charlie Lou]

How do you set focus to a control on a subform, from the main form?

 

[Ken Snell]

You need two VBA code steps to do this, the first to set focus on the
control that holds the subform, the second to set focus on the control in
the subform:

Me.NameOfSubformControl.SetFocus
Me.NameOfSubformControl.Form.NameOfControlOnSubform.SetFocus

A macro action can be used instead if you want, using the SetFocus action.
But you still need two steps.