I'm setting up a calculation in which the users select a dropdown option from 8 different combo boxes.
Each option is assigned a value that is multiplied by a factor, depending on which combo box it came from.
cboBox may have a factor of 5.
option B in that cboBox may have a value of 3.
Result, 3 x 5 = 15 for cboBox.
Each of the combo boxes will work the same way. Then, those results are added together for the final ranking to go into the textbox, Rank.
I've tried both of the calculations below in the Rank box on the Frm_ISSUES (attached), neither works, and I don't know what to try next.
Me.Rank = 7 * Me.UrgLvlWt + 5.5 * Me.VolLvlWt + 5 * Me.TrnLvlWt + 4.5 * Me.LocLvlWt + 4 * Me.PerLvlWt + 2 * Me.QtyLvlWt + 1.25 * Me.WkldLvlWt + 1 * Me.PrdLvlWt
Me.Rank = 7 * Me.cboUrgency.Column(2) + 5.5 * Me.cboVolume.Column(2) + 5 * Me.cboTurnaround.Column(2)
+ 4.5 * Me.cboUsersLocation.Column
(2) + 4 * Me.cboUsersPercentage.Colu
mn(2) + 2 * Me.cboQuality.Column(2) + 1.25 * Me.cboWorkloadMgmt.Column(
2) + 1 * Me.cboProduction.Column(2)
The calculation below does work on frmRank, but it is only numbers on that form. It doesn't display line item descriptions and reference a column related to the description.
Me.Rank = 7 * Me.Urgency + 5.5 * Me.Volume + 5 * Me.Turnaround + 4.5 * Me.UsersLocation + 4 * Me.UsersPercentage + 2 * Me.Quality + 1.25 * Me.WorkloadMgmt + 1 * Me.Production
I haven't set up the rank text box to requery, yet. So the code is run on click in the Rank text box.