#error (1 Viewer)

[drp]

hi experts

in my database main form with subform. subform have query as recordsource.
total of one of field in subform shown on main form. all is ok and show total correctly but when subform have no records then total field on main form shows #error.

I want help from experts to convert this value either into null string or zero(0).

any help will be appriciated.
thanx in advance.

 

[spikepl]

=IIf(Not IsError([sbfrmSearchOrders].[Form]![txtOrderCount]),[sbfrmSearchOrders].[Form]![txtOrderCount],0)

 

[drp]

It works fine.
Thank you very much !