Results 1 to 2 of 2
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Data in 1st form, needs to appear in the 2nd subform if there is data on the line

    I have a form wherein there is a currency exchange rate, the fields are as follows:

    Form 1
    1-ID - Autonumber
    2-Company Name
    3-Currency
    4-CurrencyRate

    Form 2 (this is a breakdown or list of purchases)
    1-ID-Autonumber
    2-Form1ID-to connect to Form 1 ID
    3-Quantity
    4-CostPrice in EUR
    5-CurrencyRate-will be taken from Form1


    6-Total cost=quantity * (#4/#5)

    I need that the currency rate in form 1 appears in form 2 for the number of lines they will enter.

    How can I make this appear in form 2.

    Thank you again for your assistance.

    Trident

    Sample: USD1.00 = EUR1.35

    The fix number is the USD and the EUR can change to any currency.

    I also have a subform inside this form.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,970
    Form 2 is subform on form 1? Expression in textbox: =Parent.CurrencyRate

    Calculate the Total: =quantity * (CostPrice / Parent.CurrencyRate)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-22-2017, 07:14 PM
  2. Replies: 8
    Last Post: 11-01-2015, 11:50 PM
  3. Replies: 5
    Last Post: 08-12-2013, 12:53 AM
  4. Line by Line Transactional Data Queries
    By defaultuser909 in forum Queries
    Replies: 7
    Last Post: 07-18-2012, 10:00 AM
  5. Replies: 2
    Last Post: 02-13-2012, 02:41 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