Results 1 to 8 of 8
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Conditional combo box


    I was wondering if it's possible to make a combo box change it's contents. I'm making an inventory database. When issuing equipment, I have an equipment type. Is it possible to make a combo box change it's drop down depending what equipment type is chosen?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    If you mean get a combo box to change its own row source, then forget it
    However perhaps you meant the following:

    The normal method is to use cascading combo boxes where the output of the first determines the row source of the second and so on.
    For example I have a form with 5 cascading combos for UK postcodes
    These 'drill down' from area to district to sector to zone to the full postcode
    e.g. BS to BS6 to BS6 4 to BS6 4E to BS6 4EW
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    That might be what I'm trying to do. I have a combo box to pick an equipment type. For instance, if the equipment type is a radio, I only want the second combo box to show the information for radios. If they choose another equipment type, example cameras, I would want that second to show only the information for cameras. Is that the cascading?

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Yes it is. This is the form I was referring to....

    Click image for larger version. 

Name:	PostcodeBuilder.PNG 
Views:	16 
Size:	85.3 KB 
ID:	33146

    You can probably find examples on this site if you do a forum search for cascading combo boxes
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I will look for them. Thanks.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I posted an example of multiple cascading combo boxes/list boxes at https://www.accessforums.net/showthr...ghlight=impact
    Post #3 (might also look at Post #9)

    Maybe it will help you......

  7. #7
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Thanks. I'll look at it. I appreciate the help.

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Conditional Combo Box on Subform
    By GregShah in forum Forms
    Replies: 3
    Last Post: 07-27-2016, 03:03 PM
  2. Replies: 5
    Last Post: 09-16-2015, 10:32 PM
  3. Replies: 2
    Last Post: 01-21-2013, 10:38 PM
  4. SubForm with query conditional combo boxes
    By ThebigCt in forum Forms
    Replies: 1
    Last Post: 02-28-2012, 05:13 PM
  5. Conditional Combo Boxes on a form
    By ThebigCt in forum Access
    Replies: 1
    Last Post: 02-06-2012, 08:08 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