Navigating Between Main Form and Subforms

[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

 

[John Vinson]

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.

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?

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