subform set focus

D

dcowper

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?
 
M

Marshall Barton

dcowper said:
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
 
Top