Results 1 to 7 of 7
  1. #1
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139

    Split Form in a tabbed Form

    I have a tabbed form when I add a split form to one of the pages, the datasheet portion of the split for is not visible. Can someone tell me if this can be fixed.

    Thank you in advance,


    Michael

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Apparently it cannot.

    Unless you want to build form/subform to emulate split 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
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139
    Quote Originally Posted by June7 View Post
    Apparently it cannot.

    Unless you want to build form/subform to emulate split form.
    How do I get the datasheet subform to show all records rather than just the one showing in the form?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Are you still referring to a split form? As far as I can tell, it cannot be used as a subform and retain the split feature.

    Have to build a form/subform in place of the split form. So you would end up with a form/subform/subsubform arrangement.
    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.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Here's a link to an article and download for emulating a Split Form that will work on a Subform. It refers to using it on a Navigation Form...but a Form on a Navigation Form is, in fact, a Subform:

    https://www.datanumen.com/blogs/how-...ess-using-vba/

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139
    Quote Originally Posted by Missinglinq View Post
    Here's a link to an article and download for emulating a Split Form that will work on a Subform. It refers to using it on a Navigation Form...but a Form on a Navigation Form is, in fact, a Subform:

    https://www.datanumen.com/blogs/how-...ess-using-vba/

    Linq ;0)>
    Thank you, this worked great. I appreciate your time.

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Glad we could help!

    Good luck with your project!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 3
    Last Post: 11-03-2015, 11:19 PM
  2. tabbed form
    By scottdg in forum Forms
    Replies: 4
    Last Post: 06-17-2015, 10:30 AM
  3. Tabbed Form versus Form with Subforms
    By dogosmond in forum Access
    Replies: 1
    Last Post: 05-03-2012, 02:25 PM
  4. can a tabbed form be too big? Help!
    By ma t in forum Forms
    Replies: 3
    Last Post: 03-10-2011, 10:03 AM
  5. Tabbed Sub Form
    By Vikki in forum Access
    Replies: 1
    Last Post: 02-10-2010, 10:30 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