Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Location
    Pullman, WA
    Posts
    4

    Unanswered: Multiple Subforms in Datasheet View

    Sorry this is probably a really newbie question.

    I have a form with 2 subforms (Access 2002). When switching to Datasheet View for the main form I get a nice little "+" icon next to the beginning of each row that when clicked pops down a "Datasheet subform" for one of my subforms.

    How do I get 2 "+" icons so that both subforms can be displayed?
    Only one subform (usually the last one added to the main form) is allowed to be displayed in Datasheet view of the main form.

    Perhaps this isn't event possible, but would be a cool feature if it exists.

  2. #2
    Join Date
    Apr 2002
    Location
    Pullman, WA
    Posts
    4

    Lame

    Ok, so according to Microsoft you can only have one nested SubDataSheet - how lame

    Hopefully they will add this feature in the future.

  3. #3
    Join Date
    Jan 2009
    Posts
    1

    Just a work around

    Fortunately there is a simple way to swap between subforms:
    1. Include subform 'A' in the main form. Name it, for instance, 'DynamicSubForm'.
    2. Put a TextBox 'Switch' on the main form, for example with a '>' in it. Put it anywhere you want, for instance as the first column. If You make it as wide as the column with the '+' in it, it looks like it is a system function.
    3. Select the main form. Put VB in the 'On Open' event:
    Me.DynamicSubform.ObjectSource = 'A'
    4. Select the 'Switch' TextBox. Put VB in the 'On Click' event:
    If Me.DynamicSubform.ObjectSource = 'A' then Me.DynamicSubform.ObjectSource = 'B' else Me.DynamicSubform.ObjectSource = 'A'
    me.refresh
    5. There are several ways to make it look even better. However, this solution works for me...

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by tbrazill
    Hopefully they will add this feature in the future.
    ROFLCOPTERZ!!! LOL

    It's more likely they will remove it... considering how much they screwed Access over with 2007, where they removed several BIG things... such as Data Access Pages, Userlevel Security, Toolbars and Menus, just to name a few.
    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

Posting Permissions

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