Ms access

[Waqarahmed]

I used this format
=Sum(nz(VAL([Forms]![subCalendar]!
[Text1])))+(nz(VAL([Forms]!
[subCalendar]![Text25]))) , but I still keep getting #Name? in my
textbox.

[cactusdata]

Val cannot neither accept nor return Null, so use:

=Sum(Val(Nz([Forms]![subCalendar]![Text1])))+Val(Nz([Forms]![subCalendar]![Text25]))

Also, do rename your textboxes to something meaningful.