Using Unbound combobox columns for calculation (XP)

[sealevel]

I have a number of multicolumn combo boxes. I wish to add (sum) the value (dollar amount) from the second column (unbound) from each combo box and display in an unbound field all on the same form.

I used: =combobox1.column(1) + combobox2.column(1). However, the values are concatenated instead of being added, although they will multi[ply if * is used instead of +.

What have I missed?

[WTH]

Hi

While I don't profess to be an expert on this I think you need to explicitly state the combo values are numbers. If Access considers them to be strings then + symbol can be confused with concating. So I would amend it to read:

clng(combobox1.column(1)) + clng(combobox2.column(1))

Regards
WTH

[sealevel]

Thankyou Thankyou Thankyou WTH, it worked. I had spent two days searching the help files and web for a solution.