Results 1 to 2 of 2
  1. #1
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107

    Multiple Drill Down Filter using DoCmd.ApplyFilter

    Hello,



    I'm would like to create a drill down form where the user can double click on a cell in a column and the form will filter the list down. See attached screenshot of my form.

    Example. I click Rev T618 and the list filters down to only T618. Then I click Planner T03 and the list is further filtered down to T618 and T03. And so on and so on. Is this possible? Thank you for your help!

    Click image for larger version. 

Name:	Capture.JPG 
Views:	10 
Size:	151.8 KB 
ID:	34913

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It is certainly doable. You can either change the record source of the form or its filter property. If the former, use a form-level variable to keep track of what you've filtered on so far, if the latter you can test the filter property of the form. This may be helpful for the delimiters required:

    http://www.baldyweb.com/BuildSQL.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 10-05-2017, 01:15 AM
  2. Multiple entries for ApplyFilter?
    By kwelch in forum Macros
    Replies: 4
    Last Post: 11-25-2016, 06:08 AM
  3. DoCmd.applyfilter for multiple
    By vicsaccess in forum Programming
    Replies: 4
    Last Post: 11-10-2015, 05:02 PM
  4. Replies: 2
    Last Post: 06-17-2015, 12:20 PM
  5. DoCmd.ApplyFilter with wild card
    By cksm4 in forum Programming
    Replies: 3
    Last Post: 10-05-2010, 08:24 AM

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