I have a form which contains a subform. The subform has several columns of which one is "Expenses" and a box "SumExpenses" which keeps a running total in euros of this column. My main form contains a box "Total Expenses" which references this running total. The main form also contains a box "Total contract value". A box "Total" adds "Total Expenses" to "Total contract value".
All this works perfectly for me whilst for each entry there are expenses in the subform. If there are no entries in the subform, however, "SumExpenses" in the subform is blank (instead of showing 0.00€ for example) and this results in the main form's "Total Expenses" also being blank. The box "Total" also comes out in blank even if "total contract value" does contain a value.
Is there a simple way to get around this problem?
Thankyou!
All this works perfectly for me whilst for each entry there are expenses in the subform. If there are no entries in the subform, however, "SumExpenses" in the subform is blank (instead of showing 0.00€ for example) and this results in the main form's "Total Expenses" also being blank. The box "Total" also comes out in blank even if "total contract value" does contain a value.
Is there a simple way to get around this problem?
Thankyou!
