Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    21

    Unanswered: How get values from one table to feed a form bound to another table

    This is going to get complicated I'm sure. But here goes. I have a table named tblPrices. I have another table named tblPartsMasters. Both of these tables have a field named "Part_No" which is the index field in both tables. Then I also have a form named frmPartsMasters which is bound to the table tblPartsMasters.

    When the form named frmPartsMasters is opened I want to have an oncurrent event that pulls data over from the table named tblPrices and feeds it into a field on the form named "txtEach_Price". The data I want to pull over from tblPrices is the field named "Each_Price". So I guess this is a DLookup function. However, certain criteria has to be met before the field named "txtEach_Price" can be populated.

    This criteria is that:
    a) A field named "Q1a" in tblPrices is null and also
    b) A field named "chkbxInclSC1" in tblPrices is false.

    Does anybody help me write this oncurrent event code?

    --Steve

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Give it a go. You are on the right track it would seem, so try it out and if it still doesn't work, post up what you have tried and then we can correct you
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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