Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2021
    Posts
    2

    Multiple Filter Dropdowns on Access Form


    I need to be able to use multiple filters simultaneously on the same form. The form consists of several filter combo boxes and data below the dropdowns. I can get it to work fine for a separate filter on one field but am unsure about how to have the filter functionality work for multiple dropdowns on multiple fields at the same time. Thank you in advance for any advice on this. btw: I am not adverse to using VBA, which is probably necessary to filter multiple fields simultaneously.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,250
    Have a look at the attached sample, you should be able to adapt it for your purpose.
    Cheers,
    Vlad
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,157
    You can utilise inbuilt filtering using the techniques described here https://www.access-programmers.co.uk...o-code.311279/
    It's very powerful with virtually no code, I'm not sure if it would help you or not.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    Join Date
    Aug 2021
    Posts
    2
    Quote Originally Posted by Gicu View Post
    Have a look at the attached sample, you should be able to adapt it for your purpose.
    Cheers,
    Vlad
    The database appears to be empty.

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Have a look at the two example databases at Multiple Group & Filter - Mendip Data Systems
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,250
    Sorry the form is hidden, just go to File\Options\Current Database and under Navigation Options check the Show hidden objects. The form name is popCustomFilter.
    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 5
    Last Post: 05-06-2016, 11:52 AM
  2. Dropdowns based on other dropdowns
    By Heathey94 in forum Forms
    Replies: 5
    Last Post: 02-12-2016, 04:55 AM
  3. Replies: 1
    Last Post: 09-16-2014, 12:52 PM
  4. Referencing Dropdowns to multiple fields
    By John Mundy in forum Forms
    Replies: 2
    Last Post: 11-14-2011, 05:15 AM
  5. Filter Report with Dropdowns
    By ShadeRF in forum Reports
    Replies: 4
    Last Post: 05-30-2011, 12:40 PM

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