Results 1 to 2 of 2
  1. #1
    hobsondm01 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    2

    Unhappy Combo Box Filters for custom navigation

    This problem has been niggling away at me for a while now.

    I have created an extensive database that holds all the data for my companies product base.
    There are 4 tables that all tie in to 1 form. Each record is one product.

    I currently have 2480 products, therefore 2480 records.

    My issue is that I have no decent way of navigating through the records.
    Im running Access 2007.

    All the data is there for it i just dont know how to utilise it.
    Here is an example row of the main product table.

    Product Type | Product Section | Product Sub-Section | Item Name

    Its a perfect product tree. Section > Sub-section>sub-sub-section.

    What i want is to be able to have three drop down boxes so when i pick a product type in the first one, only the sub sections of under that are available to click in the 2nd one, then when i pick a sub section, only the sub-sub sections are available in the 3rd one.
    Then once the criteria is selected, it will show me (somehow, a report or in a datasheet) the records that apply to those filters.



    Ive been trying to find a solution but this seems to incorporate a lot of aspects of access of which i have limited knowledge.
    i wondered if anyone knows of any way of doing this?
    Just some guidance or even some code i can manipulate to meet my ends.

    I would appreciate any help.

    Thanks

  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,640
    The concept is often called cascading combos:

    Baldy-Cascading Combos

    Opening a form/report could be done with this technique:

    BaldyWeb wherecondition
    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: 2
    Last Post: 08-18-2011, 10:20 PM
  2. Replies: 16
    Last Post: 06-21-2011, 09:08 AM
  3. Form Filters Help
    By JeffG3209 in forum Forms
    Replies: 1
    Last Post: 05-22-2011, 10:31 PM
  4. About filters
    By registan in forum Forms
    Replies: 12
    Last Post: 04-09-2011, 08:01 AM
  5. Replies: 3
    Last Post: 05-25-2010, 02:16 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