Tab to subform

[Lauren]

Hi all,

I never got a response from my post from last week so I am
trying again.

I have a main form with two subforms nested in it. Since
my users don't understand subforms, I'd like them to be
able to use the "Tab" key to each control effortlessly.
However, once I tab after the last control in my first
subform, Access automatically take me to the next record
in the same subform rather than the first control in the
second subform. I know I can hit Ctrl+Tab to advance to
the first control of the next subform and then the main
form but is there a way to program this into the form so
my users won't have to do that? Any help will be greatly
appreciated.

Thanks!
Lauren

 

[Bubba]

On the last tab item in the list, on the "Lost_Focus" event add code to set
focus to the subform. This why you do not need to add a hidden control.

 

[Lauren]

Thanks for your response.

I have heard that this is what to do but I am stumped on
the code part. This is what I tried:

Private Sub name of text box
Parent!sub name of next subform.SetFocus
Parent!sub name of next subform.Form name of control in
next subform
End Sub

Using this does not work for me. Do you have any
suggestions? I'd greatly appreciate it.

Thanks,
Lauren