Hi Ashley,
You can base your combo box(es) on value lists, or on a lookup table. Using
a table will provide you a lot more flexibility to add new colors and
associated values vs. using a value list.
So, you can have a table of colors, like this:
tblColors
ColorValue Number / Long Integer (Set as primary key)
Color Text (Create unique index)
Remove the default value of 0 from the ColorValue field. You would enter
data into this table, like this:
ColorValue Color
3 Red
4 Brown
5 Blue
6 Green
7 Gold
In form design view, add a combo box. With the combo box selected, press the
F4 button to view the properties dialog, if it is not already displayed. On
the Data tab, the RowSource for the combo box will be either a saved query or
a SQL (Structured Query Language) statement like this:
SELECT ColorValue, Color FROM tblColors ORDER BY Color;
The Control Source should be the field that you want to save the selected
value to (assuming you want to save the selections). The Bound Column should
be 1.
On the Format tab, set the Column Count to 2. Set the Column Widths to 0;1".
Give the combo box an appropriate name to indicate what entity the color is
describing. It is best to avoid the use of spaces (or any special characters)
in the names that you assign when working in Access. You can make multiple
copies of this combo box, giving each one a unique name.
Create a text box and name it txtTotalScore. The required Control Source for
this text box will be something like this for three combo boxes:
=CLng(Nz([cboCombo1],0))+CLng(Nz([cboCombo2],0))+CLng(Nz([cboCombo3],0))
where cboCombo1, cboCombo2 and cboCombo3 are the names of each combo box.
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
