> need help going from one txtbox in one subform to another textbox in
> another subform
[quoted text clipped - 7 lines]
>
> Thanks in advance for your help
In the AfterUpdate Event Procedure of the a2 TextBox:
Parent!subfrm1.SetFocus
Parent!subfrm1.Form!b2.SetFocus
In the past (Access version 97) I found that I had to set the focus on
the subform control first and then set focus on the control in that
subform. Trying to directly set the focus on a control in the other
subform in one command just didn't work; therefore, 2 commands.

Signature
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
js - 31 Aug 2005 21:23 GMT
thanks for responding - I tried but it did not worked.
i have a parent form very much like the [customer orders] in Northwind
and I also have the equivalent to
[customer orders subform1] and [customer orders subform2]
I will like to jump from [customer orders subform1] to
[customer orders subform2] if one of the textboxes in [customer orders
subform1] meets a criteria
i am also working with acc2003
thanks