Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    retrieving data from a subform into another subform

    I have text box in a subform.
    Unit cost
    I also have another sub form in that subform.
    the second one has a calculate button.
    I want to multiply the value of quantity and the unit cost and display it in the text box below the calculate button!


    please help, PM me.
    I will be pleased to give more details!

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275

    Re: retrieving data from a subform into another subform

    Depending on when you want the calculation to occur, you could use this line in VBA code:

    Me!TotalCost = Me!Quantity * Forms("TheSubForm")!UnitCost

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sum Data in a Subform
    By bdriscoll in forum Forms
    Replies: 0
    Last Post: 11-02-2008, 04:10 PM
  2. SubForm to Parent
    By henryclay in forum Forms
    Replies: 2
    Last Post: 11-15-2006, 09:44 AM
  3. Sorting in a subform
    By hraup in forum Forms
    Replies: 2
    Last Post: 08-29-2006, 12:35 PM
  4. copying data from subform to mainform
    By wasim_sono in forum Forms
    Replies: 0
    Last Post: 03-10-2006, 04:35 AM
  5. Subform in a Subform and relationships
    By St3ph3n in forum Database Design
    Replies: 3
    Last Post: 12-06-2005, 06:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums