Sub Sub Form control set focus

[Silvio]

Hello is there a way to simplify the 3 lines of codes below to set focus from
the main form to a control in subform2?

Me.frmCalibration2.SetFocus 'Subform 1
Me.[frmCalibration2].Form![frmOxygen1].SetFocus 'Subform 2
Me.[frmCalibration2].Form![frmOxygen1].Form![cmbTemp].SetFocus 'Set focus on
cmbTemp

Thank you,
Silvio

 

[Allen Browne]

No, that's right.

Each form has an active control. For the user to experience the sub-subform
control as the one that has the focus, you need to do all these:
- make cmbTemp the active control in the sub-subform,
- make the frmOxygen1 subform control the active control in the middle form,
- make frmCalibration2 subform control the active control in the main form.

 

[Silvio]

Once again thank you Allen for you response.

No, that's right.

Each form has an active control. For the user to experience the sub-subform
control as the one that has the focus, you need to do all these:
- make cmbTemp the active control in the sub-subform,
- make the frmOxygen1 subform control the active control in the middle form,
- make frmCalibration2 subform control the active control in the main form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello is there a way to simplify the 3 lines of codes below to set focus
from
the main form to a control in subform2?

Me.frmCalibration2.SetFocus 'Subform 1
Me.[frmCalibration2].Form![frmOxygen1].SetFocus 'Subform 2
Me.[frmCalibration2].Form![frmOxygen1].Form![cmbTemp].SetFocus 'Set focus
on
cmbTemp

Thank you,
Silvio