Continuous form on a subform- cangrow?

[BonnieW via AccessMonster.com]

Hi everyone! I'm using Access 2003. I have a form set up with a tab control
(two tabs). On Tab1 I have a subform with another tab control, and on
subtab1 I have a subform with a continuous subform. On the continuous
subform, my user will be entering up to 13 records, with a substantial number
of controls- a lot of screen real estate. However, on the subform of Tab2 of
the mainform, the user will likely only be entering one or two records at a
time.

So far everything functions like a champ- relationships work, queries are
timely, load time isn't bad. However, it's as ugly as a monkey's butt. If I
adjust Tab1->subtab1->subform to accomodate its potentially huge size, the
other forms look like empty wastelands- of default grey, no less.

So: my primary question is: is there a mysterious, hidden CanGrow/CanShrink
property of tab controls?
Failing that, is there a mysterious, hidden way to change the color of tab
controls? I've poked around a bit, and it seems there's a utility that does
this, but I'm not sure how it would work for me, having never used utilities-
this DB'll be something that will hopefully last my institution generations
(or at least til after I'm gone), as well as be distributed in an MDE.

Thanks in advance for any advice you can offer!

 

[Bob Quintal]

Alright, apparently I was wrong when I said it worked like a
champ. One set of tabs-> subforms works great; the other does
not. My mainform is bound and has a few controls on it. I
then have the main tabs, and an unbound subform on Tab1, which
contains more tabs, on which are more bound subforms. I would
like to be able to create link fields between the main form
and the sub-subforms, but cannot, due to the presence of the
tab-enabling unbound subform. Is there a workaround?

Thanks again!

yes there is. put a textbox on the unbound subform.
The textbox can be hidden (.visible = false)
You will need to put code in the mainform's OnCurrent event that
sets the textbox value to the key you want to relate of the sub-
subforms.
Me!child1.form!textbox = me!Key.
Change the name child1 to the value of the Controlname property
of the subform control. It may not be the name of the subform
form.

If you have a composite key, repeat for each part of the key.

You may want to put the same code in the AfterUpdate event of
the Key textbox(es) on the mainform.

Now set up the link parent Fields of the sub-subforms to the
control(s) on the subform

Q--
Bob Quintal

PA is y I've altered my email address.

 

[BonnieW via AccessMonster.com]

Alright, apparently I was wrong when I said it worked like a champ. One set
of tabs-> subforms works great; the other does not. My mainform is bound and
has a few controls on it. I then have the main tabs, and an unbound subform
on Tab1, which contains more tabs, on which are more bound subforms.
I would like to be able to create link fields between the main form and the
sub-subforms, but cannot, due to the presence of the tab-enabling unbound
subform. Is there a workaround?

Thanks again!

 

[BonnieW via AccessMonster.com]

Thank you!

Alright, apparently I was wrong when I said it worked like a
champ. One set of tabs-> subforms works great; the other does

[quoted text clipped - 6 lines]

Thanks again!

yes there is. put a textbox on the unbound subform.
The textbox can be hidden (.visible = false)
You will need to put code in the mainform's OnCurrent event that
sets the textbox value to the key you want to relate of the sub-
subforms.
Me!child1.form!textbox = me!Key.
Change the name child1 to the value of the Controlname property
of the subform control. It may not be the name of the subform
form.

If you have a composite key, repeat for each part of the key.

You may want to put the same code in the AfterUpdate event of
the Key textbox(es) on the mainform.

Now set up the link parent Fields of the sub-subforms to the
control(s) on the subform

Q

Hi everyone! I'm using Access 2003. I have a form set up
with a tab control (two tabs). On Tab1 I have a subform with [quoted text clipped - 23 lines]
Thanks in advance for any advice you can offer!