subform question

[js]

need help going from one txtbox in one subform to another textbox in
another subform

so i have

main frm -inside there are: subfrm1 (textboxes: a1 a2 a3 ) and subfrm2
(b1 b2 b3)

how do i go from txtbox a2 to b2 -- if a condition is met at a2?

Thanks in advance for your help

j

[MGFoster]

js wrote:

need help going from one txtbox in one subform to another textbox in
another subform

so i have

main frm -inside there are: subfrm1 (textboxes: a1 a2 a3 ) and subfrm2
(b1 b2 b3)

how do i go from txtbox a2 to b2 -- if a condition is met at a2?

Thanks in advance for your help

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQxYJ2oechKqOuFEgEQLCGQCfesU6CCqQbxjXJt/2oi9kJuRWPTAAoP2l
lb+NDJpTPAlkCcJEHvQUyppn
=ptLD
-----END PGP SIGNATURE-----

[js]

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