Results 1 to 7 of 7
  1. #1
    lehi53 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    28

    put a sub form in a tab control


    Whenever I try to add a subform into a tab control on my database, the subform I add appears on each of the other pages, not just the one I put it on. See attached database. IN fact both the subform and the tab control appear on each page. The subform is on the Contact Form on the General Tab. CRM v12 - Copy.zip

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    It's because don't actually have the page of the tab control selected when the controls are added and the second tab control and the subform are each installed directly on the main form.

    This can be demonstrated by moving the first tab control and see that the second tab control and the subform are unaffected and sit on the main form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407
    As June states the control has been put on the form not the tabed page.
    In design mode select the tab page that you want to put the next level of tabed page on, then from the toolbox grab the tab icon and put it on top of the existing tab page, if this is done correctly then the tab page should change color indicating that you in the correct place. The same goes for subforms but get it from the database window.

    1000 ways to skin a cat, allways looking for another one...
    Use MDB format for sample post. If your issue is fixed, mark the thread solved.
    Click on the star below if this has helped.

  4. #4
    lehi53 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    28
    Quote Originally Posted by trevor40 View Post
    As June states the control has been put on the form not the tabed page.
    In design mode select the tab page that you want to put the next level of tabed page on, then from the toolbox grab the tab icon and put it on top of the existing tab page, if this is done correctly then the tab page should change color indicating that you in the correct place. The same goes for subforms but get it from the database window.
    Even when I try to add the other tab control it puts that on all pages too. The issue is even when Im in design mode it is not changing colors. It is still asdding the subform to each main tab.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Actually, I always thought a tab control could not be on a tab control. Was hoping I was wrong and you knew something I didn't.

    I am not able to get tab control on another tab control so I believe that confirms my original understanding.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    lehi53 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    28
    Quote Originally Posted by June7 View Post
    Actually, I always thought a tab control could not be on a tab control. Was hoping I was wrong and you knew something I didn't.

    I am not able to get tab control on another tab control so I believe that confirms my original understanding.
    No problem. I will just scratch that idea. Thanks

  7. #7
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407
    Below link explains it all, I knew I'd seen it being done, but thought it was direct nesting not as shown below using a subform to hold the next tabed page.
    http://office.microsoft.com/en-us/access-help/using-the-tab-control-on-a-form-HA001230049.aspx#BM7

    1000 ways to skin a cat, allways looking for another one...
    Use MDB format for sample post. If your issue is fixed, mark the thread solved.
    Click on the star below if this has helped.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-25-2013, 02:08 PM
  2. Replies: 10
    Last Post: 02-20-2013, 07:04 AM
  3. Replies: 5
    Last Post: 06-29-2012, 10:06 PM
  4. Replies: 3
    Last Post: 03-29-2012, 12:40 PM
  5. Replies: 1
    Last Post: 05-18-2011, 07:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums