Results 1 to 2 of 2

Filter based on two combo boxes.

  1. #1
    jakeao is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2009
    Posts
    16

    Filter based on two combo boxes.

    I'm kind of a newb so please bear with me.

    I want to filter equipment issues in a multiple items form by using 2 combo boxes, and a button. Here is an example.

    I want to search every issue with the Packer on Line 1. I choose line 1 from the first combo box, which then filters the second combo box. I then choose the packer. I now want to click the button and have it show only those records that pertain to the line 1 packer. Let me know if this doesn't make sense. I've tried searching the web, but I can't find anything that makes sense. Thanks.

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,888
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Replies: 9
    Last Post: 06-04-2014, 09:45 AM
  2. Apply Filter based on unbound date boxes
    By anoob in forum Access
    Replies: 3
    Last Post: 01-21-2011, 03:26 PM
  3. Filter form from multiple combo boxes
    By Bird_FAT in forum Programming
    Replies: 6
    Last Post: 05-19-2010, 08:32 AM
  4. Using Cascading Combo Boxes to Filter a Query
    By skiptotheend in forum Queries
    Replies: 0
    Last Post: 10-13-2009, 05:57 AM
  5. Replies: 1
    Last Post: 03-01-2009, 07:53 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
  •  
Tech Forums: Microsoft Office Forums