Sum fields in subform if not Null

[atom]

Hello ,
I have a form with a textbox where user enters date , one button that requeries a subform and one SumTextbox that shows the sum of one field of subform.


When the user enters a date , that is not on a subform , subform returns blank , and on the SumTextbox I get #Error.

How can I input criteria ,so that when the field is blank ,my ResultTextbox shows 0?

By now I have tried :

= IIf ( IsNull([FieldName])  ; 0; sum( [FieldName] ))

and this : http://allenbrowne.com/RecordCountError.html
but this doesn't work

[Rainlover]

Try

NZ(Sum ( [FieldName] ),0)

Untested

FieldName must be a Field from the RecordSource of the SubForm.

If I am wrong search Help for the correct syntax.

[atom]

NZ(Sum ( [FieldName] ),0)

This didn't work either...

Someone please help

[Rainlover]

Did you go to help and check the syntax.?

Where is Field Name located?

[orange]

Are you Counting records or SUMming Values in a Field?

[atom]

I use Sum in subform,on mainform ResultTextbox has Controlsource like that:

=[subform].[Form]![SumFieldName]

where SumFieldName is the Name of textbox in subform

[Rainlover]

This has been tested.

Sum ( [FieldName] )

What result do you get.