[Solved] Mainform vs Subform Tab Order

[Hagar Delest]

I'm having an issue with the tab order of my form. There is a mainform with 3 fields and 3 subforms. I am able to adjust the tab order of fields in each of the form/subforms but I can not seem to adjust the order of the subforms in relation to the mainform. When I go to enter data, it wants to enter subform 3 data first, then mainform data, then subform 2 and 1 data. I need it to go mainform data, subform 3, subform 2, subform 1.

Any thoughts?

[Villeroy]

Create a fifth dummy form, drag the subform to that dummy and then back to the main form in right order.

[skip671]

Thanks. I figured it would be easy. Of course it puts it at the bottom, so I had to do it with each of the other subforms that I had already created. But that's no big deal. Now everything is in order and as I add new subforms, they should fall in order.

Just a quick, unrelated question. Does anyone know if there is a limit to the number of subforms that can be added to a mainform? I'm going to be looking at probably 50 or so subforms by the time this project is completed.

[RoryOF]

I'm not an expert on BASE, but my thinking is that your subforms should be dynamic - that is, created from parameters specific to each subform when called - rather than static (predefined).

[Villeroy]

Just a quick, unrelated question. Does anyone know if there is a limit to the number of subforms that can be added to a mainform? I'm going to be looking at probably 50 or so subforms by the time this project is completed.

This should be no problem. My personal maximum of nested forms is this: https://forum.openoffice.org/en/forum/v ... 00&t=70259
The form named "Knock out stage" has 16 subforms to look up data for 16 matches and the sub-subforms of these 16 take the match results as input.