Liz, the first part is behind the combo box. The second part is the sql from q_GroupHealthPlanSelection. The combo box name don’t exactly match my question. I change the question slightly to make it simpler to understand.
SELECT q_GroupHealthPlanSelection.HpnhpnID, q_GroupHealthPlanSelection.HpnPlanName
FROM q_GroupHealthPlanSelection
ORDER BY q_GroupHealthPlanSelection.[HpnPlanName];
SELECT t_HealthPlanName.HpnhpnID, t_HealthPlanName.HpnCarID, t_HealthPlanName.HpnYerID, t_HealthPlanName.HpnHarID, t_HealthPlanName.HpnNetID, t_HealthPlanName.HpnPlanName
FROM t_HealthPlanName
WHERE (((t_HealthPlanName.HpnCarID)=[Forms]![f_HealthRatesInput]![sf_GroupHealtPlanInput].[Form]![cboCarrier]) AND ((t_HealthPlanName.HpnYerID)=[Forms]![f_HealthRatesInput]![sf_GroupHealtPlanInput].[Form]![cboYear]) AND ((t_HealthPlanName.HpnHarID)=[Forms]![f_HealthRatesInput]![sf_GroupHealtPlanInput].[Form]![cboArea]) AND ((t_HealthPlanName.HpnNetID)=[Forms]![f_HealthRatesInput]![sf_GroupHealtPlanInput].[Form]![cboNetwork]));
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Subject: RE: [MS_AccessPros] Sub form sort
Hey Bill, what does the query look like for cbo4?
Please post the sql.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, January 09, 2017 2:18 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Sub form sort
Liz,
Thanks for your reply. Cbo 1,2 and 3 are not based on a query. Only cob4 is based on a query and that is where the information disappears once I select a different option for cbo3 on any of the records in the sub form.
I hope that clarifies what is happening.
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Subject: RE: [MS_AccessPros] Sub form sort
My initial takeaway was the requerying and losing the data. Have you tried to just requery the one control like cbo1.requery and cbo2.requery?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Subject: [MS_AccessPros] Sub form sort
I have a main for with a sub form. I have having trouble with a combo box on the sub form.
The main for has the customer information.
The sub form is “continuous” and c! ontains information on the customer’s health plan or plans. It is continuous because a customer can have more than one health plan.
The continuous sub form has 4 fields, all combo boxes. 3 of the combo boxes are just pulling information from tables.
Cbo 1 is the year of the health plan. For example, “2016”
Cbo 2 is the carrier of the health plan. For example, “Blue Cross Blue Shield”
Cbo 3 is the network name of ! the carrier. For example, the “Aware” network.
Cbo 4 is the health plan name. This cbo only shows the information from a query that is sorted by the information input in the prior 3 combo boxes.
So in this example combo box 4 would only show plans for 2016 with Blue Cross Blue Shield that use the Aware network. This narrows the options of the combo box down to about 10-20% of the total options and also keeps us from having to include every detail in every plan title for cbo 4.
This continuous form works fine when all of the valued in cbo 1, cbo2 and cbo3 are all the same. I can put in 2,3 or even ! 4 plan. Cbo 4 continues to work fine.
The problem is that if a! company has 3 plans as follows and on the 3rd plan! the network changes.
Plan 1 is for “2016” with “Blue Cross Blue Shield” and uses the “Aware” network. The plan could be the $3,000 deductible 100% plan.
Plan 2 is for “2016” with “Blue Cross Blue Shield” and uses the “Aware” network. The plan could be the $3,000 deductib! le 80% plan.
Plan 3 is for “2016” with “Blue Cross Blue Shield” and uses the “BLUE PRINT” network. The plan could be the $3,000 deductible 80% plan. This is the same plan as plan two but uses a smaller network.
Now when I go to cbo 4 and try to select the proper plan it is not there. If! I re-query the combo box with the information on plan 3 then I lose the selections in cbo 4 for Plans 1 and 2. Is there any way to have different variable (in this case the network) in the various records and not lose the information in the other combo boxes.
It seems can’t change and of the selections in any of the combo boxes or I have problems with losing information on the other records.
Is there any other solution to this problem that I could use?
Bill
&nb! sp;
Bill Singer
Minnesota, USA!
Access 2016
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipie! nt, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar