Erro in Calculation based on subform - Can't get sub to work!! 1

[LarryDavidow]

I have a field in the main form that calculates values from a subform. It works fine until the query that the subform is based on, doesn't return any values. I get a #error in the field.

I have tried a few things based on various posts in the forum. One of the posts that made the most sense, was to add Me.txt190 = Forms![formname]![subformname]![controlname] to the On Current event in the main form. For some reason, my field is not updating. If I change the Controlname value to a field in my main form, it works fine (data is taken from the relevant field and placed in the txt190 field)

Any pointers would be much appreciated. All I'm trying to do here is replace the #error with either Null or 0.

 

[danvlas]

=IIf(IsError(Expression), 0, Expression)

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[LarryDavidow]

Thanks Dan!!! Knew it had to be simple!!!