Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Orlando, FL
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform based on a subform

    Is it possible to base a subform on a subform. Let me explain.

    I want to keep track of a conversion we are going through. I have 3 main tables.
    - Issue table - holds description of issue and responsible employee
    -Contact Name table - names of outside vendor(s) we may contract with for that particular issue
    -Issue History table - Notes for conversations with Contact Names.

    Right now my main form is based on the Issue table and the Contact Name and the Issue History tables are subforms linked to the Issue table. I really want the Issue History linked to the Contact Name table so I can keep track of conversations per Contact Name.

    Is this possible to do or can I have a subform in a subform. In other words, have the Issue History subform as part of the Contact subform which is part of the Issue form.

    Thank you for your help.

    Larry

  2. #2
    Lounger
    Join Date
    Apr 2002
    Location
    Bloomsburg, Pennsylvania
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform based on a subform

    As far as I know you can go 3 layers deep. I've done it that way before and didn't have any problems.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subform based on a subform

    In Access 97, you can nest subforms 3 deep (parent, subform, subsubform). In Access 2000, you can go even deeper.
    Charlotte

Posting Permissions

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