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!
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...