Results 1 to 5 of 5
  1. #1
    Beanie_d83 is offline Advanced Beginner
    Windows 8 Access 2013 64bit
    Join Date
    May 2016
    Posts
    73

    Filtering Data On A Continuous Tabbed Subform

    Hi All,

    My database project has been neglected of late so thought it was about time I got stuck back into it!

    Firstly I had a rethink on what might be the best way to display the data and decided that using a continuous tabbed form would be a good approach. So far I've created a concept layout which includes numerous tabs and would like to know if it is possible to apply a filter to the data when each tab is clicked?

    Any help as always will be greatly appreciated!

    Kind regards,

    Beanie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You mean when subform on tab page gets focus? Where does filter criteria come from?

    Is main form bound? Does it have relationship with subform?
    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
    Beanie_d83 is offline Advanced Beginner
    Windows 8 Access 2013 64bit
    Join Date
    May 2016
    Posts
    73
    Quote Originally Posted by June7 View Post
    You mean when subform on tab page gets focus? Where does filter criteria come from?
    I've tried creating a query for the criteria. The screenshot below shows the PR tab selected and the continuous form displaying the data for all Group Types. I'm looking to get the form filtered by Group Type when each corresponding tab is clicked.

    The record source (if this is what you refer to as being bound?) is tbl_Part_Numbers and from what I can see it has no relationship with the sub form.

    Click image for larger version. 

Name:	Part_Reg_Tab.jpg 
Views:	10 
Size:	75.6 KB 
ID:	34751

  4. #4
    Beanie_d83 is offline Advanced Beginner
    Windows 8 Access 2013 64bit
    Join Date
    May 2016
    Posts
    73
    I have attached a copy of the DB for you to tinker with if it helps!
    Attached Files Attached Files

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I never use Navigation form - don't like it. I use normal form and Tab control.

    The tabs of Navigation form do have Click event. However, you have not attempted any code in those events nor in the command buttons.

    Since each tab of Part Register references the same form object, I think Navigation form is unnecessary complication. It could make sense if each tab was a different form for different data. So the first Navigation form is reasonable but the secondary level is over complication in my view. Same for Hydraulic Rams and Assemblies.

    I would use normal form and code that sets Filter and FilterOn properties of form. Review http://allenbrowne.com/ser-62.html
    I suppose that can still be done on a Navigation form, I've never built it.
    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.

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

Similar Threads

  1. Replies: 9
    Last Post: 06-28-2018, 06:41 AM
  2. Filtering a Continuous Form
    By kdbailey in forum Access
    Replies: 4
    Last Post: 03-29-2017, 10:40 AM
  3. Filtering Data in a Subform for a form
    By mchadwick in forum Forms
    Replies: 1
    Last Post: 01-02-2015, 01:54 PM
  4. Replies: 14
    Last Post: 03-11-2013, 09:27 PM
  5. Filtering a continuous form
    By sbrookebounds in forum Forms
    Replies: 10
    Last Post: 08-14-2012, 09:56 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