Form / Subform Control Issue

T

tina

in the last control in the tab order of your subform, add
code to the OnExit event, as

Me.Parent.ControlName.SetFocus

change "ControlName" to the name of the control you want
to go to on the main form. (i think i got the syntax right
for the Parent reference. if it won't work, you can use
Forms!MainFormName! instead of Me.Parent.)
fyi, this can be a pain if your user tries to click on
another control on the main form or the subform, while the
control that runs the code has the focus - regardless of
where the user clicks, the focus will move to the control
specified in the code.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Focus to SubForm Control 10
setfocus on form control, not subform 4
Tabbing through form w/ subforms 1
Subformss, Tab Controls, and Forms 1
Subform Current event firing twice with paradoxical Me keywordbehaviour 3
Getting a subform control to requery 3
running a subroutine from the parent form 2

Top