Subforms and focus (1 Viewer)

urobee · Aug 12, 2019

Hy,

Currently I try to build a database with tons of forms.
There are 3 level with subforms and the subforms contains tabs.
My problem is setting the focus on the subforms to see the tabs on top .
I've made the trick with the 0x0 size textbox and the tab order. It works fine with one subform but not works with three subforms.
How can I set up the focus to never change on the levels. Every time i select something the focus is jumps to the database level (third level) so i can't see the tabs on the subforms. I would like to hide the scroll bars too, so it's not possible to adjust them all the time to see the tabs.

Is there any trick to set the focus somehow to the top of the forms?
Thank You!

arnelgp · Aug 12, 2019

explain in short Map, ie:

Code:

MainForm
          Subform1
                   Subform2
                        Tab Control
                           Subform tab1
                           subform tab2

so we can image the depth of your form.

you must adjust the height of each subform inside the tabcontrol so you may see the tabs.

urobee · Aug 12, 2019

I hope this will help:

First I select a tab on layer1 then select a tab on layer2 then fill the form on layer 3.
I deleted the 1x1 textbox from all layers so now everything is in default.
When I click on a tab on any layer the focus goes to the subform on the next layer so I can't see the tabs, need to adjust with the scroll bar.

arnelgp · Aug 12, 2019

the scroll bar is in each subform's (form) property.
don't you think it's a little weird.

urobee · Aug 12, 2019

That You can see is the subform1's scroll bar.
There are three vertical scroll bars- one for each subform but those aren't on the picture.
(There are horizontal scroll bars too but those aren't on the picture)

arnelgp · Aug 12, 2019

open each subform in design view and on its Property->Format->Scroll bars->None.
you also don't need: Record Selectors and Navigation button.

Pat Hartman · Aug 12, 2019

When I click on a tab on any layer the focus goes to the subform on the next layer so I can't see the tabs, need to adjust with the scroll bar.

You need to adjust the size of the outer form so it is large enough to hold and SHOW all of the details. NO ONE wants to scroll a form to see more of it (this is what i hate the most about web pages) although they don't mind scrolling down a list to see more records.

FIX your form layout. Reduce the space or make the form larger. You might want to try using the tab view. I don't like it and never us it but you seem to like tabs a lot so go for it.

Subforms and focus (1 Viewer)

urobee

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

urobee

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

urobee

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Pat Hartman

Super Moderator

Similar threads

Users who are viewing this thread