A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subforms



 
 
Thread Tools Display Modes
  #1  
Old November 20th, 2008, 05:23 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Subforms

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...
  #2  
Old November 20th, 2008, 05:58 PM posted to microsoft.public.access.tablesdbdesign
Beetle
external usenet poster
 
Posts: 1,254
Default Subforms

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


"Mani" wrote:

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

  #3  
Old November 20th, 2008, 08:43 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Subforms

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" wrote:

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


"Mani" wrote:

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

  #4  
Old November 21st, 2008, 08:04 AM posted to microsoft.public.access.tablesdbdesign
Beetle
external usenet poster
 
Posts: 1,254
Default Subforms

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


"Mani" wrote:

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" wrote:

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


"Mani" wrote:

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

  #5  
Old November 21st, 2008, 08:34 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Subforms

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?

"Beetle" wrote:

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


"Mani" wrote:

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" wrote:

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


"Mani" wrote:

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

  #6  
Old November 21st, 2008, 09:49 PM posted to microsoft.public.access.tablesdbdesign
Beetle
external usenet poster
 
Posts: 1,254
Default Subforms

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


"Mani" wrote:

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?

"Beetle" wrote:

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


"Mani" wrote:

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" wrote:

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


"Mani" wrote:

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

  #7  
Old November 22nd, 2008, 03:51 AM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Subforms

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

"Beetle" wrote:

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


"Mani" wrote:

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?

"Beetle" wrote:

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


"Mani" wrote:

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" wrote:

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


"Mani" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.