issues with #error can't seem to supress it

[sspreyer]

issues with #error can't seem to suppress it

=[PaymentSearch subform].[Form]![Total]

tried 

=nz([PaymentSearch subform].[Form]![Total],0)
get !#size error

hi ,all

i wonder if someone could help me. I'm trying to suppress the #error when the total is null.

see above is what i have tried with no avail :banghead:

any help much appreciated

thanks in advance
Shane

 

[sneuberg]

A null total shouldn't cause an error. That reference does't look right. Try

=Forms![PaymentSearch subform].[Form]![Total]

and if that doesn't fix it could you upload your database? If not post the SQL of the subform record source query.

 

[sneuberg]

If Total is a control with a calculation and that calculation has an error then it would show up in this textbox too. Not knowing what Total is I refer you to this site as a long shot.

 

[sspreyer]

If Total is a control with a calculation and that calculation has an error then it would show up in this textbox too. Not knowing what Total is I refer you to this site as a long shot.

yeah this works on the sub form. but the calculation is being carried on to the main form i still get #error

working on subform

IIf(FormHasData([Form]),Sum([Job Cost]),0)

thanks

shane

 

[CJ_London]

what is the FormHasData function?

What are the parameters to the function (e.g. frm as form or something else)?

What is [Form] - is it a field name? supposed to refer to the form object?
where are you using this code as it is not clear. As written it should be in vba (in which case you use Me - not [Form], if the controlsource to a control it should be preceded with =

and

=nz([PaymentSearch subform].[Form]![Total],0)

would normally be written as

=nz([PaymentSearch subform].[Form].[Total],0)

 

[sspreyer]

i have now worked it out thanks guys

this is my solution

=IIf(Not IsError([PaymentSearch subform].[Form]![total]),[PaymentSearch subform].[Form]![total],0)