Tab stops with subforms

[tonyblazek]

Hello all, I have a form that has 2 subforms. Does anyone know how to make the tab stop move on to the next subform? Right now once in the first form the tab cycles within the form and won't move onto the next form. Thanks, Tony

 

[Lightning]

Hi Tony

You can do this with code within the first subform.

You can set code to run whenever a particular event occurs. I tend to use a field being null.

In the field's after update event, test for the field's value. If it is null, move back to the parent form, otherwise do something else on the subform.

If IsNull(Myfield) then
Parent.Setfocus
Parent.NextSubform.Setfocus
Else
...Do something here
End If

HTH

Lightning