Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Kentucky, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    continuous form/subform question (Access XP)

    I know Access 97/2000 don't let you put a subform on a continuous form, but is this the case in Access XP and 2003? Is there any good way to "mock" this design?

    Thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: continuous form/subform question (Access XP)

    It's impossible in Access 2002; I don't know about Access 2003, but I suspect that it won't be possible there either.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: continuous form/subform question (Access XP)

    About the only thing you can do is use side-by-side subforms. The 1st one will be your continuous form. The 2nd one will only display a single and will be based on the value in the 1st subform. So as you move from row-to-row on the 1st subform, the 2nd subform will change.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: continuous form/subform question (Access XP)

    Keep in mind that a continuous form is an illusion, which is one of the reasons you can't put a subform on one. Each visible record in a continuous form is using the same set of controls and populating a subform for each record would make the complexity pretty nearly unmanageable. A continuous form is intended to display multiple records, so what would be the purpose of taking up space with a subform? All that would accomplish is to reduce the number of records you could view at a time. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    One workaround is to put a button in the detail section on your continuous form. When the button is clicked, you can pop up another form displaying additional information about that current record, such as whatever it is that you were thinking of displaying in a subform.
    Charlotte

  5. #5
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: continuous form/subform question (Access XP)

    You can put a subform on a continuous form in 97 to view drag the subform into the continuous form footer and link by your key field

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

    Re: continuous form/subform question (Access XP)

    But what would be the purpose of putting it in the footer?
    Charlotte

  7. #7
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: continuous form/subform question (Access XP)

    Pretty much the same as putting a button on the main form, except the subform records will change in sync as you scroll down through the records on the main form. I'm not sure it's a good way of entering information, the main form can look crowded, but it's useful for quickly scrolling through existing entries.

Posting Permissions

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