I have a sum control in a footer of a subform. The control appears OK in form view (for the subform) but in the designer view the control has disappeared... OK ignore this. I found the sum in the datasheet view.