Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Question Unanswered: Problem with calculation from subforms

    I have a main form with two subforms. At a minimum, weight is inputted on to one subform. When there are additional spools, these weights are added to the other subform. I want to total all of the weights form both both subforms and disply this total on the main form.

    The following works as long as weights have been inputted on both subforms. When weight is inputted only on the Receiving_Round Subform, it doesn't give me a total value on the main form.

    =(([Forms]![Receiving_Round]![Receiving_Round Subform].Form!SumWeight)+([Forms]![Receiving_Round]![Receiving_Round Subfrm2].Form!TotalWeigh))

    Can anybody help me with this? I don't understand why it is working this way.

  2. #2
    Join Date
    Sep 2003
    Test each control in the subforms for not null before doing the calculation ...

Posting Permissions

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