[Solved] Mainform vs Subform Tab Order

Creating and using forms

[Solved] Mainform vs Subform Tab Order

Postby skip671 » Mon May 07, 2018 10:13 pm

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?
Attachments
Capture.JPG
Capture.JPG (21.7 KiB) Viewed 994 times
Last edited by Hagar Delest on Tue May 08, 2018 2:46 pm, edited 1 time in total.
Reason: tagged [Solved].
Apache OpenOffice 4.1.3
Windows 7
skip671
 
Posts: 2
Joined: Mon May 07, 2018 10:04 pm

Re: Mainform vs Subform Tab Order

Postby Villeroy » Tue May 08, 2018 10:25 am

Create a fifth dummy form, drag the subform to that dummy and then back to the main form in right order.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26700
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Mainform vs Subform Tab Order

Postby skip671 » Tue May 08, 2018 1:37 pm

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.
Apache OpenOffice 4.1.3
Windows 7
skip671
 
Posts: 2
Joined: Mon May 07, 2018 10:04 pm

Re: [Solved] Mainform vs Subform Tab Order

Postby RoryOF » Tue May 08, 2018 3:09 pm

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).
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28912
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Mainform vs Subform Tab Order

Postby Villeroy » Wed May 09, 2018 3:59 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26700
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests