I have a form with a number of subforms.
On the main form, there is a control to adds up the subtotals on each of the subforms.
Sometimes, the underlying query for a subform my have no results. This is ok and on purpose.
The problem is, though, that I get #Error instead of a total on the main form.
I'm assuming it's because the subtotal on the subform control is blank, or null, or empty, or whatever the correct terminology is.
How can I force this control to be 0 when the query returns no records, so that it doesn't mess up my other controls?