How to handle no record when passing value

[jkfeagle]

I have a form and within that form a subform. The subform is a listing of payment history and in the footer is a hidden sum. That sum is passed to the main form and works fine as long as there is a record for that case number. However, if there is no record with that case number it shows #Error in the field. Now, trying to trap the field as null or non-zero doesn't work (I tried anyway) obviously because it's not passing ANYTHING, not even a null value. There simply isn't a corresponding record. How do I get around this so that it either shows a zero in the control on the main form or simply doesn't show anything?

 

[pbaldy]

http://www.mvps.org/access/forms/frm0022.htm

 

[jkfeagle]

Great! Thanks pbaldy!