Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    subforms (97 and 2000)

    This question is about Access 2002. Can somebody tell me if the number of subforms which can be linked to a main form is still two as in Access 97 and Access 2000. I have a situation where I need a main form with 3 sub forms related to each other.
    TIA
    Pat

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

    Re: subforms (97 and 2000)

    I don't understand the question. There was no limitation of two subforms on a form in Access 97 or 2000. There are limitations of nested subforms, if that's what you mean. In Access 97, you could only nest them 3 deep: parent form, subform, subsubform. In Access 2000, you can nest up to 5 deep. I assume 2002 is the same but I can't test it until Microsoft releases their forthcoming hot patch.
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    <P ID="del"><FONT SIZE=-1>Post deleted by patt</FONT>

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subforms (97 and 2000)

    Pat,

    In the help file search for:
    create one or more subforms

    BTW according KB article Q214651, Access 2000 can have 7 nested subforms.
    Francois

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Thanks Charlotte,
    You were right, it's about nesting subforms. I need to nest up to 3 levels under the main form. How do I do that? Is there any doco I can read to give me any ideas. Actually I would appreciate it if you have an example that you might email to me as I have to get something going for work tomorrow. My email address is pthorn@unite.com.au or at work pthorn@smorgonsteel.com.au
    TIA
    Pat

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Thanks Francois,

    The help you gave me says that you can only have 2 nestings deep, or is this a hangup from Access 97.
    I include the quote from Access 2000 help:
    ----------------------------------------------------------------------------------------------------------------------------
    Create a form with a subform that contains another subform
    Before using this procedure, make sure you've set up your table relationships correctly.

    You can use this procedure to create a form and two levels of subforms that have a one-to-many relationship. The main form has a one-to-many relationship with the first subform, and the first subform has a one-to-many relationship with the second subform.
    ----------------------------------------------------------------------------------------------------------------------------

    How do I goto KB and find the article that you found? If you have an example I would appreciate it.

    TIA
    Pat

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subforms (97 and 2000)

    Pat,
    the link to the KB is here
    In the left part of the screen, you can select the product in the combo and type keywords in the textbox under it.
    It is sometimes difficult to find keywords that match your problem, so you have to try again and again with different combination of keywords to narrow your search.
    Success
    Francois

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Thanks,
    I found my way there eventually, however, I am still having trouble setting up a main form and three nested continuous (can I use continuous for my subforms?) subforms. My subforms need to be continuous subforms.
    TIA
    Pat

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subforms (97 and 2000)

    Pat,

    I have been playing a little with nested subforms.
    I find out that a subform that contains another subform cannot be displayed as continous form. You have to display it in Single or Datasheet format.
    Is this your problem?
    Francois

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Francois,
    That's part of the problem. My requirement is I need to show the subforms as a continuous type of form. In Access 97 when I needed to go 2 levels deep I would just set up a text field on the main form that got part of the key of the 1st subform that the 2nd subform then used to display records related to the 1st subform record. The 2 subforms were laid out on the main form and not with the 2nd subform embedded into the 1st subform.
    The problem with displaying the 2nd subform in datasheet format is that I cannot nest any deeper than that, am I correct in saying that?
    Thanks
    Pat

  11. #11
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Charlotte,
    What is the forthcoming "Hot Patch" all about?
    Is it related to the subform problem I am having?
    What SR are we up to with Access 2000, I ask, as I have not used Access 2000 much, I'm still deeply into Access 97.
    Thanks for your help
    Pat

  12. #12
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subforms (97 and 2000)

    Pat,
    <hr>The problem with displaying the 2nd subform in datasheet format is that I cannot nest any deeper than that, am I correct in saying that?<hr>
    This is not correct.
    See the attached mdb where there are 3 nested subform in datasheet view (you have to click on the + to see the subforms for each record.
    Don't look to the design and content, it mean nothing, was made in 10 min.
    Attached Files Attached Files
    Francois

  13. #13
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subforms (97 and 2000)

    Francois,
    Thanks for that, obviously that is how nesting works and is displayed. I was of the notion that it could be displayed like Access 97 where the 2 subforms were displayed independantly of each other on the main form yet were related by the special text field that was required to be setup.
    Pat

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

    Re: subforms (97 and 2000)

    The hot patch in question applies to the problem with running Access 2000 and 2002 on the same machine. Nothing to do with 97 and 2000.
    Charlotte

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

    Re: subforms (97 and 2000)

    That that was merely a particular way of syncing multiple subforms, not a way of nesting them. You could nest subforms in Access 97 but only to the SubSubform level, and only the innermost subform could be displayed as a continuous form or datasheet.
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

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