Bill apparently your are filtering one or more combo boxes based on the value of a previous combo box. When I do something similar with cascading combo boxes, I don't filter the combo box Row Source. I sort the Row Source so the appropriate values float to the top. In addition, I will add a column that identifies if the item selected is valid and if not, notify the user.
Duane Hookom
Sent: Monday, January 9, 2017 1:37 PM
To: 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 contains 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 deductible 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
Bill Singer
Minnesota, USA
Access 2016
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar