I have a data entry form with 3 subforms.
The tab order won't allow me to tab out of one subform into another field,
and so on into other subforms etc.

Is there a work around ??

Jack

Perhaps defining some visual basic code on the field you are leaving e.g.
if the field is fldItemNumber on subform sfrmItems and after that you want
to jump to the field fldQuantity on subform sfrmOrderLine you could define
a function on fldItemNumber attribute AfterUpdate in wich you set focus the
field fldQuantity on sfrmOrderLine.

Sub fldItemNumber_AfterUpdate()
sfrmOrderLine.fldQuantity.SetFocus
End Sub

In stead of 'sfrmOrderLine.fldQuantity.SetFocus' i think you can also use
'me.parent.sfrmOrderLine.fldQuantity.SetFocus' if you want to be sure you
get the right instance of that subform.

You might want to add ErrorHandling in case the other subform is not there...

Kees de Boer


Jack wrote: