Results 1 to 5 of 5
  1. #1
    angybab is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2020
    Posts
    18

    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,366
    Cascading combo boxes sound like the perfect solution for this. For an example, see http://www.mendipdatasystems.co.uk/c...xes/4594455723
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    angybab is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2020
    Posts
    18
    Thanks, it worked

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,366
    Excellent. Glad to have helped!
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    Join Date
    Oct 2020
    Posts
    2
    Cascading combo fields I remember helped me when got a job at Orbex Space. I remember that there was a test task on this topic

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 - Senior Forums