Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    133

    Unanswered: newbie question: multiple and deduct data retrieved from subform

    Hi,
    I have a main form named product with 3 subform: Initialstock, take in, take out
    I created a text box named "remained" in mainform and want to sum the Initialstock with take in, and then deduct the take out by this:
    =InventorySubform!initialstock+SubDelivery!shiped-[Stockout Subform]!out

    but it not works. could you tell me in detail the way to solve it. thanks
    I post my file for you for reference.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487

    Cool

    Okay....I'll brave this one...and to make it all as quick and painless as I can...Use this line instead of yours.


    =([Forms]![products]![InventorySubform]![Initialstock]+[Forms]![products]![SubDelivery]![shiped])-[Forms]![products]![Stockout Subform]![out]




Posting Permissions

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