totals 1

[jazz007]

How do i add 3 columns which are combo boxes in a sub form, columnA, columnB , columnC.

=(columnA + columnB + columnC)

I tried that and it did not seem to work, any other solutions, that may help

 

[Crowley16]

are all 3 boxes formatted as number?

comboboxes can have multiple columns, you could try ColumnA(1) + ColumnB(1)...

assuming the value is in column1 of columbA/B

--------------------
Procrastinate Now!

 

[jazz007]

Further to this

columnA = combo267
columnB = combo268
columnC = combo269

all i would like to do is add the combo267 + combo268 + combo 269. I have not used forms that much but may need a bit of guidance on this

can anyone help

 

[Crowley16]

just add the contents of the combo boxes...

combo267 + combo268...

--------------------
Procrastinate Now!

 

[ZmrAbdulla]

All your comboboxes must be formatted to number then Control Source of the textbox where you want the total to be appeared type like below.
=[combo267]+[combo268]+[combo269]
If they are not formatted to number then it will display like
10+10+10=101010
else it will display to the correct value =30
By the way, You have placed a lot of combo on the form(may be deleted) now the count 269 I don't know if it will allow you place any more.

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.