I'm trying to understand how you get 8 selections from a single combo box?? There are probably a dozen ways to do this.
- 8 coloured rectangles with a textbox beside each for setting a value? You'd have to ensure someone cannot pick the same number 2x.
- same rectangles with cascading combo beside each. You choose a value, value is dropped from subsequent combo list but user has to choose in order.
- same rectangles; remove the chosen value from an array, each subsequent combo gets its values from what's left in the array.
- if not an array, a module level variable that starts out with an 8 value combo value list. Each combo pick uses Replace function to remove the chosen value from the list. Each combo dropdown looks at the remaining list values
- etc
Your table would need at least 2 fields; 1 that represents the colour, 1 that is for the rank given. Thus after 7 tests, you'd have 56 records (7x8) and could query to select red and count where rank = 1 (or 2 to see how many times it came in second). Possibly might do a Totals query also to show how many times yellow was #x ( a cross tab would require at least 3 fields, I believe). If you increase the count for any particular ranking, then you are storing calculations, which is usually discouraged.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.