You should be able to add an abbreviation of the plan to the display.
You can create a calculated column to sort on
IIF(t_HealthPlanName.HpnNetID=[Forms]![f_HealthRatesInput]![sf_GroupHealtPlanInput].[Form]![cboNetwork],-1,1)
Duane
Sent: Tuesday, January 10, 2017 9:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Sub form sort
Duane,
That may work but it makes naming the plan very difficult because sometimes we have a plan called the "$3,000 ded – 100%" that is in the Aware network and the same plan, "$3,000 ded – 100%" that is in the Blue Print network.
So now I would have the same name in the combo box
I could see the following in the combo box.
"$3,000 ded – 100%"
"$3,000 ded – 100%"
"$3,000 ded – 100%"
Three different plans with different rates because they use different networks but the same name because mechanically the plans work the same.
How would you solve that issue?
My only thought would be to add information in the name of the plan, but that is what I was trying to avoid because the names get so long. Such as below.
"$3,000 ded – 100%" Aware Network
"$3,000 ded – 100%" Blue Print Network
"$3,000 ded – 100%" Choice Netowk
Thanks for your suggestion. 2nd question. How do you get the most appropiate plan to FLOAT to the top. I would be interested in that.
Thanks you,
Bill Singer
Minnesota
Access 2016
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, January 9, 2017 3:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Sub form sort
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
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
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 (10) |
Tidak ada komentar:
Posting Komentar