Code to tab out of a subform???

[BCarruth]

Is there any way to code a way out of a subform rather than use the control/tab keys (or is it alt/tab keys?)?
Thanks
Bob

 

[Lightning]

Use an appropriate event to set the focus back to a control on the parent form.

I use the Exit event of a control on the subform. If the control is empty/null, move back to the main form, otherwise do something else on the subform.

'If the MyField field is empty, exit the subform and
'return the focus to the MyForm form.
    If IsNull([MyField]) Then
        Parent![Tenant].SetFocus
    Else
        ...do something else
    End If

Hope this helps.
Lightning

 

[BCarruth]

Thank you very much!!
The code worked perfectly.

Bob

 

[Lightning]

Glad it helped!

Lightning