I have a Form. On that Form I Have a textbox where I display an amount from a formula that pulls totals from 3 Subforms.
The 3 Subforms Each have a textbox in the header where I Sum([TrAmt]) . Each Subform is based upon a different query.
Everything works right until in that Main Form textbox on the Main Form UNLESS one of the SubForm's queries is Null.
I have tried nz(Sum([TrAmt],0) but if the Subform's query is null that textbox field just displays as blank. Then the Main Form's textbox goes into an #Error state.