Navigating Between Main Form and Subforms

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

1. My main data entry table has three tabs which
correspond to different stages of our business process.
How I can open this form, displaying the appropriate tab,
based on a menu selection from a switchboard form.

2. One of the tabbed forms has three detail (one to many)
subforms. It seems awkward to force my user to abandon
the keyboard and mouse click to the next subform. Is
there a more elegant way to move from subform to the next,
and back to the main form?

Thanks for all assistance.

Kevin Sprinkel
 
1. My main data entry table has three tabs which
correspond to different stages of our business process.
How I can open this form, displaying the appropriate tab,
based on a menu selection from a switchboard form.
Click to expand...

You'll need some VBA code in the Form's Load event to do this -
setting the tab control's Page property to 1, 2 or 3 as appropriate.
2. One of the tabbed forms has three detail (one to many)
subforms. It seems awkward to force my user to abandon
the keyboard and mouse click to the next subform. Is
there a more elegant way to move from subform to the next,
and back to the main form?
Click to expand...

Ctrl-Tab will tab out of a subform to the next control in the
mainform's tab order (which might be another subform).
 
Back
Top