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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|