Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    19

    Unanswered: Form/subform question

    With the help of this forum I recently created a form which looks at a master table containing fault details, and a subform which allows the inout of labour costs to a second table, linked by the fault reference (I created a relationship).

    Now I'd like to add a second subform which links a third table in which I can enter spare parts that have been ordered from that same form. I tried creating a relationship betwen my master "faults" table and a new "parts" table and then creating a copy of the first subform but that didn't quite work.

    Can anyone tell me if this is possible?

    Many thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I've created a main form with like 10 subforms, so yes, it's possible.

    Why didn't it "quite" work?
    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

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You may want to create the 2nd subform from scratch rather than copying the first subform (perhaps using the wizard on creating the 2nd subform). As StarTrekker stated, you can have many subforms within a main form, each subform based on 1 of the relational tables to the "master" table. You can even have another subsubform within the subform (if for example you have another table linked to the table which then in turns links to the master table), and so on (but you'll lose the continuous form view in subsubforms. When you look at the design properties of each of the subform's within the main form, make sure you have the linked master/child field property set correctly for the join on the tables.
    Last edited by pkstormy; 01-13-08 at 20:55.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Dec 2005
    Posts
    19
    Thanks for the replies.

    Initially I could input data to my first subform but when I added a second nothing worked. However, I've done it again and this time I created all the subforms from scratch and it works

    Thanks very much your help!

Posting Permissions

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