subform set focus

[Guest]

I'm trying to go from one subform to a different subform on the same main
page. The only way it will let me set the focus to the next subform is in
exit of the form but I need to do it after I update the last record in the
first subform?

any ideas?

 

[Marshall Barton]

I'm trying to go from one subform to a different subform on the same main
page. The only way it will let me set the focus to the next subform is in
exit of the form but I need to do it after I update the last record in the
first subform?

First set the focus to the subform control, then set it to a
control in the subform:

Parent.subform2.SetFocus
Parent.subform2.sometextbox.SetFocus