Odd behaviour after tabbing between subforms

[Malin]

Hi, I'm trying to tab between subforms and main form and I'm using the
tips I've found in this forum;
Forms![FORM_NAME]![SUBFORM_NAME].Form![SUBFORM_CONTROL_NAME].SetFocus

And the tabbing now works, but the behaviour otherwise is very odd.
When tabbing to subform1 from mainform, I can not use the mouse in
subform2. And when tabbing from subform1 to subform2, I can not use
the mouse in subform1. That form is completely blocked, I have to tab
into it again.

I can use the mouse in the mainform in all situations, but after
placing the cursor in a textfield in it and then tabbing, the focus
might end up randomly in any field.

What am I missing ???

Many thanks for all help

 

[John Vinson]

I can use the mouse in the mainform in all situations, but after
placing the cursor in a textfield in it and then tabbing, the focus
might end up randomly in any field.

What am I missing ???

Oddly enough, you need to setfocus TWICE - first to the target Subform
control, and only then to the textbox or other form control on that
Form.

John W. Vinson[MVP]