Results 1 to 4 of 4
  1. #1
    angybab is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2020
    Posts
    35

    creating very long lists


    Hello all, am a new access user. Am tring to create a list of codes to choose from using a List field. My problem is the list is very long with subgroups. For example a list of cars, with subgroups car A, car B, car C,........car Z
    Each of this sub groups has a list of variables (about 100 to 200 variables), the idea is any time I select any of the assigned list, the sub group should be displayed. Is there any elegant way to do that? I will appreciate any help

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Cascading combo boxes sound like the perfect solution for this. For an example, see http://www.mendipdatasystems.co.uk/c...xes/4594455723
    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
    angybab is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2020
    Posts
    35
    Thanks, it worked

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Excellent. Glad to have helped!
    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

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

Similar Threads

  1. Creating Set Lists for Band
    By twjones in forum Access
    Replies: 2
    Last Post: 12-03-2018, 02:49 PM
  2. Creating Lists in microsoft access
    By mndauber in forum Access
    Replies: 4
    Last Post: 05-18-2018, 02:59 PM
  3. Replies: 1
    Last Post: 11-30-2013, 03:43 AM
  4. Creating Client Lists in Access
    By Charalampos in forum Access
    Replies: 2
    Last Post: 03-11-2011, 10:22 AM
  5. Creating single lined lists from reports
    By trikosuave in forum Reports
    Replies: 4
    Last Post: 02-14-2011, 08:10 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