When Checkbox = True Calculated Text Box Shows #Error

[Rik_StHelens]

Hi all,

I have a text box on a form which is a calculation based on two other text boxes bound to a query. The code for this text box is as follows:

=IIf([Forms]![frmQuote]![Check47]=True,(Sum([Text72]*[Text64]),"0"))

When Check47 = True the text box displays #Error, and when Check47 is False it is blank.

The other two text boxes contain a General Number (Quantity) and Currency (Delivery Excess)

Any help would be much appreciated!

Thanks in advance!

 

[bob fitz]

What is the purpose of the Sum() function in the expression?
What result do you get without it:

=IIf([Forms]![frmQuote]![Check47]=True,[Text72]*[Text64],"0")

 

[Rik_StHelens]

Thanks for that Bob!

I thought that as it was a calculation Sum was necessary, but removing it worked just fine!

Thanks for your help.