Multiple Combo Box Values Won't Sum Unless All Are Populated

[CCRT]

I have 6 combo boxes on a form (cbodd1, cbodd2.......cbodd6)

I have a text box "Sec1Sum" with this expression =([cbodd6]+[cbodd5]+[cbodd4]+[cbodd3]+[cbodd2]+[cbodd1])

The problem is if one or more of the combo boxes are not populated the "Sec1Sum" remains blank. I've tried using the Iff statement on each cbo to populate with a zero but have had no luck.

Thanks for any help

Dave

http://home.comcast.net/~ccrt-racing/ccrt.htm

 

[CCRT]

Seems I figures out a way using the Nz function.

http://home.comcast.net/~ccrt-racing/ccrt.htm