Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013
    Posts
    2

    Smile List box that is query-able depending on drop down choice on same form

    I am attempting to have a list box generate three different possible list based on what the user picks from a drop down on a field on the same form need help...

    Example drop down field 1 , Choices are: key 1, key 2, key 3

    if they pick key 2 it would like maybe 6 items, if they picked key 3 it would list 12 items



    I set up three different query's which all work and return all the correct items

    but when I change the choices for field 1 it still only returns the master list all


    THANKS IN ADVANCE

  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
    Here are a couple of methods:

    Baldy-Cascading Combos

    You could change the row source to your 3 queries as well.
    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: 7
    Last Post: 01-31-2024, 09:57 AM
  2. Replies: 7
    Last Post: 09-03-2015, 11:31 AM
  3. Replies: 0
    Last Post: 07-15-2015, 02:22 AM
  4. Replies: 2
    Last Post: 03-11-2015, 07:45 AM
  5. Replies: 4
    Last Post: 06-16-2011, 09:30 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