Results 1 to 4 of 4
  1. #1
    dante2004 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    21

    Query(?) with dependant results?

    Forgive the question and probably the wrong terms that I'm using...it's been awhile since I regularly used Access beyond the VERY basics.



    If someone can point me in the right direction, I can probably dig up the instructions on my own...but since I don't even know what this is called, I can't even begin to search. haha

    I'm building an NCR (non-conformance report) database for work. I need to create drop down menus that only show valid results based on the previous selection.

    As an example, using something we are probably all at least somewhat familiar with, say you were building a database of cars.

    You would have a Table of Cars:
    Tahoe
    Cadillac
    Corvette
    Camaro
    Explorer

    The user would select the first option from the form:

    Number of Doors: (drop down) 2, 4

    Based on their selection on that drop down, the following choices (cars) would be reduced to only those cars with 2 or 4 doors. So if the user selected "2 doors" the next menu would only show "Camaro, Corvette"

    Is this down through queries? Essentially filtering a table based on the value of a column?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sounds like cascading combos:

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

  3. #3
    dante2004 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    21
    I'll check that out, thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck. Welcome to the site by the way!
    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: 5
    Last Post: 05-21-2013, 02:21 PM
  2. Replies: 3
    Last Post: 05-02-2013, 10:36 AM
  3. Only allow values dependant on other box
    By AussieGal in forum Access
    Replies: 1
    Last Post: 03-28-2013, 03:22 AM
  4. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  5. Replies: 1
    Last Post: 03-22-2010, 03:37 PM

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