Hiding subforms

  • Thread starter Thread starter Griffij
  • Start date Start date
G

Griffij

Hide my subforms

Hi I have a database with one Main form and 4 Subform.
With all the subforms attached to the main form it it
makes it very crowded.

When I open the Main form can I hide the 4 subforms so I
only see the main form? bu then click on a button for the
sub form thus hiding the main form but showing the
subform?
 
Yes, set the Visible property of the control on the main form that is holding the subform
to False.
 
In these cases I prefer the use of a tab-control in the
lower part of the form. I use the upper part of the form
for the identifying data like an ID or a name and other
fields I want to be visible all the time.
In your case the first (most left) page of the tab-control
could contain the data you want to hide when you show a
subform. The other pages contain one subform each. Of
course you can arrange your fields and subforms any way
you want.

The lower part
 
-----Original Message-----
Hide my subforms

Hi I have a database with one Main form and 4 Subform.
With all the subforms attached to the main form it it
makes it very crowded.

When I open the Main form can I hide the 4 subforms so I
only see the main form? bu then click on a button for the
sub form thus hiding the main form but showing the
subform?
Click to expand...

subformcontrolname.vislbie = true
or
subformnamecontrol.visible = false
 
How do you add tabs to a form
-----Original Message-----
In these cases I prefer the use of a tab-control in the
lower part of the form. I use the upper part of the form
for the identifying data like an ID or a name and other
fields I want to be visible all the time.
In your case the first (most left) page of the tab- control
could contain the data you want to hide when you show a
subform. The other pages contain one subform each. Of
course you can arrange your fields and subforms any way
you want.

The lower part
.
Click to expand...
 
Click on the tab control and then right click and select Insert Page

Or

Click on the tab control and select Insert: Tab Control Page from the menu.

Tricky part is making sure you've selected the Tab Control and not one of the
existing pages.
 
Not quie what I meant,

Let me see if I can explain it any better

I have 3 sub forms annd a main form

I have created all the forms and they are all linked by
relationship. what I am want t do is link them all by
tabs at the top of the form.

Problem One:

I firsty of allt drew the forms and and then place the on
a tab page then that would of been it. Not quite you
click on any other form than the main on it did not
relate.

Problem two:

You drew the Subfor on the main for it work a treat but
it made the form look very messy.

So I thought you could just draw the tabs on but It
doesn't work please help
-----Original Message-----
Open the toolbox, click on the Tab Control and draw it onto the form.

Tom.
Click to expand...
 
Try using the TAB tool.. It works very well for this kind of problem. It's a container which can be easily created to hold a variety of subforms, fields etc and makes your for come together nicely
 
Back
Top