Going from a control in one subform to another subform

[zevw]

HI !!

I need help, I am opening a main form which has 2 subforms.

What I want to do is, after I enter info in the 1st subform, it should with the DoCmd.GoToControl, go to the control in the second subform so that the user can enter his info there, and not jump to the next record within the same subform (which in essence is a table).

Any suggestions on this will be very helpful.

Thanks;

 

[Nancy2]

I'd insert code on the after update (or insert) event of the first subform which

1) GoTo Control to get into the second subform
2) Setfocus to go to a specific control in the second subform.