Subforms... New record?

[Guest]

I have a form with a subform and I can tab through from the form to the
subform while entering information, it all works until I get to the end of
the subform. The subform is the last infomation that needs to be entered and
I would like the tab control to tab to the next empty record at the top of
the main form. The tab just continues to tab through the subform, is there
anything I can do to get the tab to go to the next empty record? I have
tried the tab order menu and it hasnt helped. Please Help! Any suggestions
will be appreciated. Thank you in advance!
Sincerely,
Cathleen

 

[Rick Brandt]

I have a form with a subform and I can tab through from the form to
the subform while entering information, it all works until I get to
the end of the subform. The subform is the last infomation that
needs to be entered and I would like the tab control to tab to the
next empty record at the top of the main form. The tab just
continues to tab through the subform, is there anything I can do to
get the tab to go to the next empty record? I have tried the tab
order menu and it hasnt helped. Please Help! Any suggestions will
be appreciated. Thank you in advance!
Sincerely,
Cathleen

<Ctl-Tab>

 

[Guest]

THANK YOU!

<Ctl-Tab>

 

[Guest]

but how can i set it in vb so that the user can use tab and not need to use
ctl-tab ??

thanks,

sam

 

[Guest]

Private Sub LastFieldinSubForm_LostFocus()
SendKeys "^{TAB}"
End Sub