Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: How do I 'link' subforms to records within a form?

    ABout 18 months ago I devloped a simple database that takes some information in an excel file and drops it into a table, which I can then use to run simple queries (grouping etc). It consists of a single table that gets added to every time I import from the spreadsheet.

    However, I now want to add more information to the individual records, which are all unique, by manually keying this into a form. I have started by creating a seperate table and relating this back to the original using a 'one-to-many' join. I have also created my form and subform but am stuck because I can't force information keyed into the subform to match with the original record id found in the original table.

    I'm sure it must be something simple but can't for the life of me figure out what that is, even after studying the "Orders" form and subform in the Northwind database that I've been using as an exmaple. Any advise would eb gratefully appreciated.


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Use the Link Child Fields and Link Master Field properties for the subform object.
    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