Results 1 to 4 of 4
  1. #1
    SltPhx is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41

    Exclamation Creating dynamic drop down list

    Hello All,


    I want to create a drop down list that is dependent on a control button. Drop down menu changes depending on the value entered in another field. Is this possible?
    Example:

    If ListBox1 = 1
    Then ListBox2 drop down menu = a,b,c,d


    If ListBox1 = 2
    Then ListBox2 drop down menu = x,y,z

    If ListBox1 = 3
    Then ListBox2 drop down menu = l,m,n,o,p


    Please let me know if this is possible.

    Thank you in advance.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Listbox controls and combobox controls are very similar. Try searching this forum or google for "cascading combo boxes".
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,615
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    SltPhx is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41
    June 7,
    That tutorial was amazing! It worked.
    You are amazing!

    Thank you. I appreciate your time and help!

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

Similar Threads

  1. Create Dynamic Drop Down Menu
    By jmfranqui in forum Access
    Replies: 1
    Last Post: 02-02-2012, 12:11 AM
  2. Creating a Dynamic Query
    By gdshih in forum Queries
    Replies: 4
    Last Post: 11-28-2011, 02:13 PM
  3. Creating dynamic hyperlinks
    By mattellenburg in forum Access
    Replies: 1
    Last Post: 11-28-2011, 10:31 AM
  4. Creating a Dynamic Query
    By JackRush in forum Queries
    Replies: 2
    Last Post: 06-26-2011, 10:47 PM
  5. Replies: 4
    Last Post: 06-16-2011, 09:30 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