Page 1 of 1

[Solved] Mainform vs Subform Tab Order

PostPosted: Mon May 07, 2018 10:13 pm
by skip671
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?

Re: Mainform vs Subform Tab Order

PostPosted: Tue May 08, 2018 10:25 am
by Villeroy
Create a fifth dummy form, drag the subform to that dummy and then back to the main form in right order.

Re: Mainform vs Subform Tab Order

PostPosted: Tue May 08, 2018 1:37 pm
by 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.

Re: [Solved] Mainform vs Subform Tab Order

PostPosted: Tue May 08, 2018 3:09 pm
by 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).

Re: Mainform vs Subform Tab Order

PostPosted: Wed May 09, 2018 3:59 pm
by Villeroy
skip671 wrote: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.