Question Form Errors

[SewerRat]

Hi all does anyone know how to stop #error coming up on forms?

I have a from that looksup calculations from a number of queries and then averages them out on the top of the form. My problem is that on some occasions I will open the form and it will display #error instead of the percentage I'm expecting. I've found for the most part that if I simply select design view and then return it to the form view that the form recalculate properly this time and gives me the correct score.

My form opens on a button so should already be refreshing the scores anyway. Does anyone know what might be causing this error and how I can get around it?

Thanks

 

[boblarson]

Might be caused by NULL values. So, if you have something like

=[Field1] + [Field2]

you can use

=Nz([Field1],0) + Nz([Field2],0)

 

[SewerRat]

yea i've already tried that and have it so that it ignores the Null values, it just seems to be a refreshing error.

Is there anyway to get it to keep refreshing until a certain box is equal to or greater than a value?

Thanks for the idea though!

 

[RossWindows]

If you are running the calculations from code, you might be able to use a loop like;

Do Until Not IsNull(YourValue) or YourValue <> ""
Your Code Here
Loop