Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subdatasheet, or not (2003+)

    Well here's the scenario (as I remember it anyway), I need to have an form for selected users to be able to enter/amend data. There are 3 tables, one at the top and the other 2 with one-many relationships (ie levels 1, 2 & 3).

    When I attempted to create the form & subforms, I was not able to have the 2nd level subform as a continuous form, because it too had a sub form.

    As a workaround, I simply put this 2nd level in as a table, with the 3rd level as a subdatasheet (I know, I know <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> )

    This all worked until I split the db; now the subdatasheet is missing & I don't know what is the best way around this <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

    <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Attached Files Attached Files

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

    Re: Subdatasheet, or not (2003+)

    Although you cannot insert a continuous subform in the detail section of a contiuous form, you can insert it in the form header or footer of a continuous form.
    So you could make the 2nd and 3d levels continuous forms, and place the 3rd level in the footer of the 2nd level.

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subdatasheet, or not (2003+)

    Cheers mate.

    I'll rebuild that then.

Posting Permissions

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