I have a main form (Accounts) that contains a subform (subPayActive) which is based on a query. In the form footer of subPayActive is a text box control that sums the values of [Payment]. On the main form, Accounts, I have another text box that has it's control source set to the sum'd text box on subPayActive. Everything works great as long as there are values for [Payment]. If this field is ever null, I get the dreaded #Error.
I've tried using the following two lines in the control source of the text box on form Accounts, but I still get #Error: