Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Summing controls in multiple subforms

    I have a database that contains a main form. On the main form, I have two subforms, each of which contains a calculated control. I am trying to create a calculated control on the main form that sums the two calculated controls on the subforms. The problem is that I keep getting a "#Error" in the control box on the main form. I am not sure why this is happening - my theory is that the subform controls are not retaining the value but at this point, I really have no idea. Any suggestions on how I can get the control on the main form to do the calculation correctly?? Thanks.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    you can address a subform control with:

    obviously you can add (if addition is logical) any number of controls from any number of subforms.

    make sure you know the name that the mother form uses for the "hole" each subform lives in

    make sure each control has something that can be added ...maybe nz() helps

    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts