Results 1 to 4 of 4
  1. #1
    hazeleyre23 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    34

    Opening Subform within a Subform Access 2007

    Hi,

    I need to create a back button as part of my project I am currently working on.

    I have a main form and within that form I have around 8 sub forms, therefore If the back button is clicked then I need it to open the previous subform and hide the subform it is on.

    Is this possible please?



    Thanks

    Hazel

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I would use a TAB control to help control space. 8 subforms would take up all the form space,
    And possibly run out of memory.

    instead, the tab control would have the 8 tabs and only 1 subForm control.
    when user picks a tab,it swaps out the subForm.
    One of these subforms could have a subForm.

  3. #3
    hazeleyre23 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    34
    How would I open the next tab and the subform on that tab?

    Thank you

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you click a tab, the tabs are always visible.
    subform is in the tab

    Click image for larger version. 

Name:	tabs.jpg 
Views:	8 
Size:	15.4 KB 
ID:	27933

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

Similar Threads

  1. Show image in subform , Access 2007
    By s128 in forum Forms
    Replies: 1
    Last Post: 06-03-2013, 06:46 AM
  2. Access 2007 - Multiple Subform Onload
    By ilikebirds in forum Access
    Replies: 3
    Last Post: 12-10-2012, 02:48 PM
  3. Junction table in subform in Access 2007
    By BrizzoRay in forum Forms
    Replies: 1
    Last Post: 12-18-2011, 01:43 AM
  4. Replies: 6
    Last Post: 10-21-2011, 10:24 PM
  5. Replies: 3
    Last Post: 08-08-2010, 05:33 PM

Tags for this Thread

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