If subfrm = Empty then = 0 else total subfrom value

[iProRyan]

Hi Guys



This problem is doing my nut in now!!

Basically I have a text box on my main form which is calculates a total of all 'Sub Total' fields displayed on the sub form, but if this is subform is empty which it will be to start with I want it to simply say "£0.00" I've tried so much IIFIsNull, other IIf.

Someone must know how to fix this, any help is appreciated!

Thanks in advance!

Ryan

[ItsMe]

I usually do calcs like that using DAO and variables. The first totals are run by a query joined to the form's data set. The final sum(s) of the TOTALS query are done in VBA behind the form and displayed in unbound control(s). An If Then Else statement can show a default value and change ForeColor properties in said control when a specific condition is met.