Results 1 to 11 of 11
  1. #1
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6

    Tab Controls


    MS Access Version 2007 running on XP-SP3. I have created a Form and on the Form I have added a Tab Control with two pages. On the first page I have added fields from one table and on the second page I have added fields from another table. These tables have a relationship on a common field. In Design View all fields are visible. When I select Form View the form goes blank. I have saved the form and and re-opened it but it still does not display. The Form will display if I only use fields from a single table. The critical point I notice is adding a field from another table. I would be very grateful if anyone has any suggestions on how I can get round this issue. Thanks Karl

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Put SubForms on your tab pages, each bound to a different query of a table.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    Put SubForms on your tab pages, each bound to a different query of a table.
    .

    Would you be able to tell me how I can achieve your suggestion. I have attached a file to demonstrate what I have tried.

    Many thanks

    K@rl

  4. #4
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    Put SubForms on your tab pages, each bound to a different query of a table.
    .

    Hi

    The Icon appears to be grey'd out?

    Cheers

    K@rl

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    What icons? Do you have a form that uses one of the tables you talked about? Can you put it on the tabbed form as a SubForm?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  6. #6
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    What icons? Do you have a form that uses one of the tables you talked about? Can you put it on the tabbed form as a SubForm?
    Many thanks for taking the time to reply. I believe that to add a Subform to an existing form, then you would go into Design mode of the existing form, click on the subform Icon (Which is found in the Design menu, under the Tools section of the Access Ribbon) and then add to the form. This is the Icon that is greyed out. Would this process be correct to add a sub form?

    Thanks in advance.

    K@rl

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    The first step would be to have a form that displays one of your tables as you desire. You would then add that form to the tabbed form as a SubForm. Do you have that 2nd form?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  8. #8
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    The first step would be to have a form that displays one of your tables as you desire. You would then add that form to the tabbed form as a SubForm. Do you have that 2nd form?
    Hi This worked for me. Thank you very much for all of your help and enjoy the rest of your day. Many thanks K@rl

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Great! Are you ready to follow the link in my sig and mark this thread as Solved?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  10. #10
    karlhardeman is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    Great! Are you ready to follow the link in my sig and mark this thread as Solved?
    HI
    Love to, but the only options Under Thread Tools is Show Printable Version and eMail This Page. Cheers. K@rl

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Hmm...strange. I'll do it for you.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. form controls & recordset
    By slow&steady in forum Forms
    Replies: 2
    Last Post: 06-25-2010, 02:49 PM
  2. Help with calculated controls
    By DannyV in forum Forms
    Replies: 2
    Last Post: 04-20-2010, 12:07 PM
  3. Controls don't work on subforms
    By rscott7706 in forum Forms
    Replies: 8
    Last Post: 03-07-2010, 10:17 PM
  4. calendar controls
    By kganomega in forum Access
    Replies: 0
    Last Post: 12-16-2009, 12:34 PM
  5. Adding Controls to a Form
    By msmayhew in forum Programming
    Replies: 7
    Last Post: 12-14-2005, 03:26 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
  •  
Tech Forums: Microsoft Office Forums