Transition from Main form to subform...to particular field

S

Shek5150

Greetings...I have a main form w/ a sub form... i need the tab order to go
from the last field on main form...to...the first field on my sub-form.

What's currently happening, is that when I tab out of the last field on my
main form, access is remembering the last field I used in the sub-form (on
previous entry) and tabbing me back to that field in my current entry...

How do I correct this so tab order is consistent...

Thanks...
 
T

tina

open the main form in design view, click on the subform control to select
it. in the Properties box, add a SetFocus action in the Enter event, as

Private Sub MySubformControlName_Enter()

Me!MySubformControlName!MyControlInSubform.SetFocus

End Sub

substitute the correct names, of course.
note: a subform control only has two events - Enter and Exit. if you see
more events listed in the Properties box Events tab, you've selected the
wrong control.

hth
 
Top