Sum of unbound text boxes not appearing in Form Footer

[tim_tims33]

Hi, I thought this would be straightforward.

I have a form with a subform of various items, each with an associated cost. If the user ticks 'paid' field, it should not contribute towards the Sum of the individual costs.



For the subform, in the footer, i have tried various permutations to get the Sum of the Amount Remaining textbox (which is unbound). For example, I've tried :

=Sum([txtAmountRemaining])

=Sum(Nz([txtAmountRemaining],0))

These expressions return an error in the textbox #Error.



When run, it shows error message:



Any ideas on why it's not returning a value?

[Gicu]

Try to use the original expression in the Sum() function instead of referencing the control:
=Sum(IIF([Paid]=False,....)

Cheers,

[CJ_London]

Not sure why you are summing on what appears to be a single form but either way, you cannot sum unbound textboxes because the summing is based on the form's recordset.

As an alternative to Gicu's suggestion, include the calculation in your form recordsource - but note this will not recalculate until the record is saved.

[tim_tims33]

Thanks Gicu. This worked first time.

[Gicu]