A2007/A2010. I have a form I call from the another form's command
button. Docmd.OpenForm "SummaryData"

The form SummaryData summarizes data that comes from a variety of
sources. When that form opens the OnCurrent event either opens the 6
datasheets that make up the detail for that record or else I filter
the datasheets if I used a NavigationButton.

The issue I have is that tabbed document order on the screen that was
created when the datasheets initially open. The left tab is the
calling form, the next 6 forms are the datasheets, and the rightmost
tab is the "Summary" form. I would prefer the tabbed order to be
CallingForm, SummaryForm, and then the datasheets. Is there anyway I
can set up the tabbed order so it fits my preference?

On 15/10/2011 8:40 AM, Patrick Finucane wrote:
Hello Patrick

I have been out of programming for a spell, but I recall you can set the
<TabOrder> of your TabControl just as you would on you forms
TabControlOrder.

You might also be able to do it via code if the above is incorrect,
maybe something in the OnKeyPress() isolating the <TAB> Key.

Air-Code:

If Me.TabKey = True Then
DoCmd.Goto "MyTab"
End If

Now this code syntax is probably all wrong, but it may point you in the
right direction.

HTH
Mark.

On Oct 15, 10:03*pm, ML <ma... (AT) camerons (DOT) com.au> wrote:
Thanks for your input. In A2007/2010 theres a navigation bar on the
top of a form for "tabbed documents". When you open a form, the form
appears on the bar. Open a table or queiry and that name appears on
the bar. Same with a report. Close any and the closed item gets
removed off the bar. Kind of a "build your tabs on the fly" via
opening or closing objects. It simply seems weird that I call a form
and that form opens several forms that the called form ends up being
the rightmost tab on the bar.