Hiding subforms

[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?

 

[Wayne Morgan]

Yes, set the Visible property of the control on the main form that is holding the subform
to False.

 

[Jos W]

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

 

[Guest]

-----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?

subformcontrolname.vislbie = true
or
subformnamecontrol.visible = false

 

[Guest]

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
.

 

[tom]

Open the toolbox, click on the Tab Control and draw it onto the form.

Tom.

 

[John Spencer (MVP)]

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.

 

[Griffij]

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.

 

[Guest]

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