Subforms

[Mani]

Hi! Sorry for my lack of terms when trying to explain my problem, but I am a
newbie. Here goes the question. I have a Main form, which is embedded with
3 subforms, When I add a subforms to the main form, for some reason, the
subforms are not functioning the same way as the its original form (i.e. The
Main Form is titled Copy of frm Global, and in the Copy of frm Global it has
Demographics subform, Services subform, and Program Inf subform ( each of
these subforms obviously was created as an individual form first) so anyways
the original forms for each is functioning properly, but when I go to the
Copy of frm Global, the subforms are not functioning properly. I hope this
makes sense.... Please help me... I run into problems right after another...

 

[Beetle]

Could be that you have form references somewhere that need to be
modified now that you have placed the forms inside another form, but
it's hard to say because we don't know what you mean when you say
"not functioning properly".

 

[Mani]

For example, i've syncrhonized combo boxes in the original form (ProgramInfo
form) and it is functioning properly, but when i go to the Form Global (where
the ProgramInfo form is embedded) it is not functioning right... what i mean
by that is when i select comb 1 the combo two is not populating the correct
values.... please help....

 

[Beetle]

First, just for informational purposes, when you add a form inside another
form (as a subform), it goes inside a Subform Control, which is basically
the window that holds and displays the subform. Depending on how you
add the subform, the Subform Control may, or may not, have the same name
as the subform itself. This is an important distinction because when you want
to reference a control or a value on a subform, you need to do so through
the Subform Control.

Now onto your problem. Your second combo box probably uses a form
reference in it's criteria to retrieve the value from the first combo box.
Probably something like;

"Select ThisValue From ThatTable Where ThisValue=" &
Forms![ProgramInfo]![Combo1]

This reference is valid as long as ProgramInfo is open on it's own.
However, as soon as you make it a subform inside another form the
reference will no longer work, because for Access to be able to find
ProgramInfo, it needs to first look at it's Parent form, and then the
Subform Control. So the reference would need to be modified like;

Forms![Form Global]![ProgramInfo].Form![Combo1]

The reference to [ProgramInfo] (right after [Form Global]) is a reference
to the Subform Control (not the subform itself). In this example I have
assumed that it has the same name as the subform, but remember that it
may not. In that case you would need to use the actual name of the
Subform Control in place of [ProgramInfo].

 

[Mani]

Beetle,
Thanks so much for your help! I tried modifying the criteria as you've
instructed but it's still giving me parameter and combo 2 box is still not
functioning properly. When you say Subform Control, where do I find that?

First, just for informational purposes, when you add a form inside another
form (as a subform), it goes inside a Subform Control, which is basically
the window that holds and displays the subform. Depending on how you
add the subform, the Subform Control may, or may not, have the same name
as the subform itself. This is an important distinction because when you want
to reference a control or a value on a subform, you need to do so through
the Subform Control.

Now onto your problem. Your second combo box probably uses a form
reference in it's criteria to retrieve the value from the first combo box.
Probably something like;

"Select ThisValue From ThatTable Where ThisValue=" &
Forms![ProgramInfo]![Combo1]

This reference is valid as long as ProgramInfo is open on it's own.
However, as soon as you make it a subform inside another form the
reference will no longer work, because for Access to be able to find
ProgramInfo, it needs to first look at it's Parent form, and then the
Subform Control. So the reference would need to be modified like;

Forms![Form Global]![ProgramInfo].Form![Combo1]

The reference to [ProgramInfo] (right after [Form Global]) is a reference
to the Subform Control (not the subform itself). In this example I have
assumed that it has the same name as the subform, but remember that it
may not. In that case you would need to use the actual name of the
Subform Control in place of [ProgramInfo].
--
_________

Sean Bailey

For example, i've syncrhonized combo boxes in the original form (ProgramInfo
form) and it is functioning properly, but when i go to the Form Global (where
the ProgramInfo form is embedded) it is not functioning right... what i mean
by that is when i select comb 1 the combo two is not populating the correct
values.... please help....

 

[Beetle]

Open you main form in design view and then select your Subform
Control (make sure you select the Subform Control and not the subform
itself). When the Subform Control is selected, the thin black line that
surrounds the subform will be highlighted (the same one you would use
to increase or decrease the size of the subform display). Once that is
selected, open the properties sheet, go to the Other tab, and see what
is listed in the Name property. This is the name you need to use in your
form reference for your combo box.
--
_________

Sean Bailey

Beetle,
Thanks so much for your help! I tried modifying the criteria as you've
instructed but it's still giving me parameter and combo 2 box is still not
functioning properly. When you say Subform Control, where do I find that?

First, just for informational purposes, when you add a form inside another
form (as a subform), it goes inside a Subform Control, which is basically
the window that holds and displays the subform. Depending on how you
add the subform, the Subform Control may, or may not, have the same name
as the subform itself. This is an important distinction because when you want
to reference a control or a value on a subform, you need to do so through
the Subform Control.

Now onto your problem. Your second combo box probably uses a form
reference in it's criteria to retrieve the value from the first combo box.
Probably something like;

"Select ThisValue From ThatTable Where ThisValue=" &
Forms![ProgramInfo]![Combo1]

This reference is valid as long as ProgramInfo is open on it's own.
However, as soon as you make it a subform inside another form the
reference will no longer work, because for Access to be able to find
ProgramInfo, it needs to first look at it's Parent form, and then the
Subform Control. So the reference would need to be modified like;

Forms![Form Global]![ProgramInfo].Form![Combo1]

The reference to [ProgramInfo] (right after [Form Global]) is a reference
to the Subform Control (not the subform itself). In this example I have
assumed that it has the same name as the subform, but remember that it
may not. In that case you would need to use the actual name of the
Subform Control in place of [ProgramInfo].
--
_________

Sean Bailey

For example, i've syncrhonized combo boxes in the original form (ProgramInfo
form) and it is functioning properly, but when i go to the Form Global (where
the ProgramInfo form is embedded) it is not functioning right... what i mean
by that is when i select comb 1 the combo two is not populating the correct
values.... please help....
:

Could be that you have form references somewhere that need to be
modified now that you have placed the forms inside another form, but
it's hard to say because we don't know what you mean when you say
"not functioning properly".
--
_________

Sean Bailey


:

Hi! Sorry for my lack of terms when trying to explain my problem, but I am a
newbie. Here goes the question. I have a Main form, which is embedded with
3 subforms, When I add a subforms to the main form, for some reason, the
subforms are not functioning the same way as the its original form (i.e. The
Main Form is titled Copy of frm Global, and in the Copy of frm Global it has
Demographics subform, Services subform, and Program Inf subform ( each of
these subforms obviously was created as an individual form first) so anyways
the original forms for each is functioning properly, but when I go to the
Copy of frm Global, the subforms are not functioning properly. I hope this
makes sense.... Please help me... I run into problems right after another...

 

[Mani]

Beetle,
Thank you sooooo soooo soooo much millions of time!!! I got it to work!! You
guys are doing such a good job and thanks so much for your patience and
responding to my questions with interest!!! Love you guys!!!

Open you main form in design view and then select your Subform
Control (make sure you select the Subform Control and not the subform
itself). When the Subform Control is selected, the thin black line that
surrounds the subform will be highlighted (the same one you would use
to increase or decrease the size of the subform display). Once that is
selected, open the properties sheet, go to the Other tab, and see what
is listed in the Name property. This is the name you need to use in your
form reference for your combo box.
--
_________

Sean Bailey

Beetle,
Thanks so much for your help! I tried modifying the criteria as you've
instructed but it's still giving me parameter and combo 2 box is still not
functioning properly. When you say Subform Control, where do I find that?

First, just for informational purposes, when you add a form inside another
form (as a subform), it goes inside a Subform Control, which is basically
the window that holds and displays the subform. Depending on how you
add the subform, the Subform Control may, or may not, have the same name
as the subform itself. This is an important distinction because when you want
to reference a control or a value on a subform, you need to do so through
the Subform Control.

Now onto your problem. Your second combo box probably uses a form
reference in it's criteria to retrieve the value from the first combo box.
Probably something like;

"Select ThisValue From ThatTable Where ThisValue=" &
Forms![ProgramInfo]![Combo1]

This reference is valid as long as ProgramInfo is open on it's own.
However, as soon as you make it a subform inside another form the
reference will no longer work, because for Access to be able to find
ProgramInfo, it needs to first look at it's Parent form, and then the
Subform Control. So the reference would need to be modified like;

Forms![Form Global]![ProgramInfo].Form![Combo1]

The reference to [ProgramInfo] (right after [Form Global]) is a reference
to the Subform Control (not the subform itself). In this example I have
assumed that it has the same name as the subform, but remember that it
may not. In that case you would need to use the actual name of the
Subform Control in place of [ProgramInfo].
--
_________

Sean Bailey


:

For example, i've syncrhonized combo boxes in the original form (ProgramInfo
form) and it is functioning properly, but when i go to the Form Global (where
the ProgramInfo form is embedded) it is not functioning right... what i mean
by that is when i select comb 1 the combo two is not populating the correct
values.... please help....
:

Could be that you have form references somewhere that need to be
modified now that you have placed the forms inside another form, but
it's hard to say because we don't know what you mean when you say
"not functioning properly".
--
_________

Sean Bailey


:

Hi! Sorry for my lack of terms when trying to explain my problem, but I am a
newbie. Here goes the question. I have a Main form, which is embedded with
3 subforms, When I add a subforms to the main form, for some reason, the
subforms are not functioning the same way as the its original form (i.e. The
Main Form is titled Copy of frm Global, and in the Copy of frm Global it has
Demographics subform, Services subform, and Program Inf subform ( each of
these subforms obviously was created as an individual form first) so anyways
the original forms for each is functioning properly, but when I go to the
Copy of frm Global, the subforms are not functioning properly. I hope this
makes sense.... Please help me... I run into problems right after another...