eliminate the error#

I am creating a form (invoice) that has three subforms. In the form there are three subtotal controls. One for each subform. Each subform lists the products or services provided and their cost.

The form works fine when there is items listed ineach subform. If there are no records in a subform I get the error# in the subtotal controls and in the Totals control. There has to be a setting I’m missing that will allow a 0 to appear if there are no records to calculate.

I’ve read a brief description on Nz but not sure how that works.

Does anyone have a suggestion.

Thanks