Form order control of Tabbed Documents

[BlindSquirrel]

How can the form order be controlled for tabbed document forms? Not the tab order on a form from control to control rather which form tab is furthest to the left. Each tabbed form is logically associated to a primary form in this project. The primary forms must be displayed to the left of the associated/secondary forms. Opening the forms in a particular order has allowed some flexibility but not enough.

[andy49]

Right click on the tabs and move the tab order up or down if I remember correctly

Is this what you mean?

[aytee111]

Have a routine which closes all forms each time and reopens them in the order you want.

[BlindSquirrel]

Not very pretty. Will be a challenge as these forms are opened dynamically based on user input and those that would need to open first rely on the foreign keys in the data set of yet to be opened forms. Looking for the method or property that can be managed through the interface or VBA to control the tabbed document order. Seems intuitive to the purpose of tabbed docs in a relational database design.

[BlindSquirrel]

No option is available on my tabs to "move the tab order." Tried to drag them too similar to IE/Chrome...nope won't budge. Let me know if I am misunderstanding you. and Thanks!

[aytee111]

Have the secondary forms as subforms on the primary forms, instead of opening them separately. You could use a tab control with multiple subforms if more than one is needed.

[HiTechCoach]

How can the form order be controlled for tabbed document forms? Not the tab order on a form from control to control rather which form tab is furthest to the left. Each tabbed form is logically associated to a primary form in this project. The primary forms must be displayed to the left of the associated/secondary forms. Opening the forms in a particular order has allowed some flexibility but not enough.

Sure. You can hide the forms (. Visible = false). Then unhide then (.Visible = True) in the order you want from left to right.

Have not tried it but it should be possible to make a pop-up for that would allow you to reorder the forms.

[HiTechCoach]

Have the secondary forms as subforms on the primary forms, instead of opening them separately. You could use a tab control with multiple subforms if more than one is needed.

That works fine as long as the sub forms don't reference controls on each other. In that case the references get tricky to create unless you use TempVars.

[BlindSquirrel]

Manipulating the forms.visible property did the trick for me. Thanks. Too bad MSA doesn't facilitate this control.

[HiTechCoach]

Manipulating the forms.visible property did the trick for me. Thanks. Too bad MSA doesn't facilitate this control.

You're welcome.

Glad that worked for you.