summing sub forms

[reel knotty]

Ok guys I have a form with 3 subforms in the main form. all 4 forms (main and 3 subs) have calculations that I would like to total. I do have sums in each subform but not all subforms are used for each entry. When I use all of the fields my grand total works fine but if I don't complete all of the fields the grand total will not calculate. I tryed setting default values to 0 so there would be something there to sum but it doesn't seem to work the way I expect. Any input is greatly appreciated!!

Nate

 

[fratezone]

you may want to include Not IsNull in your code. I think that may do the trick

 

[Rich]

Look up the IsNumeric function

 

[Fizzio]

Or even the Nz function

 

[reel knotty]

I tryed all of the suggestions and the Nz function did the trick!! Thanks Fizzio. And if you feel the need send me one of those sweet brown ales over here

 

[Fizzio]

Here you go, a six pack!

 

[Rich]

Coal Tar is cheaper, same stuff anyway

 

[reel knotty]

ooooohh yeah thats the stuff. Thats nectar of the gods compared to this stuff over here!

 

[ColinEssex]

I prefer Newcastle Amber myself - although Fiz thinks its a girls drink.

Col

 

[reel knotty]

brown ale is all I've ever seen here.