Calculating sum of selected option/combo boxes

[SgtSaunders69]

I have a survey form which collects information from a series of 20 or so option boxes. Each option boxes is set up to provide an integer (1 or 2 or 7 or 134....) as the result of user selection of one of the provided options in the particular box. I want to create a text box in the header of the form which will as the field in each option box is selected take the number related to that selection and display a running sum of all currently selected option boxes on the current record. Any thoughts on how to go about this would be greatly appreciated...!



Thanks...

[June7]

What do you mean by option boxes - a combobox? Each box is bound to a field? You will have to build an expression in textbox ControlSource that adds the boxes: a + b + c + ... with a, b, c representing the field/combobox names.

[CTdbdev]

I'm trying to do something similar here, but how should the expression be formatted in the textbox controlsource so it actually does arithmatic?

=([Combo233].[Column](2)+[Combo237].[Column](2))

With the above expression, the texbox just literally lists both price values, i.e. (0.12.25)

Regards,
Alex

[June7]

Looks like your expression is not pulling the value of the combobox but content of column that is not the bound column.

Wrap at least one of the terms in Val() function.

[CTdbdev]

Ok. I understand that now. Thank you!