Results 1 to 4 of 4
  1. #1
    byulogia@gmail.com is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2019
    Location
    Papua New Guinea
    Posts
    22

    Combo List


    Hello Access Champ

    I have a list of province name and district names (province 22 and districts 89).
    I don't want the long list of districts

    I want the districts to be limited to the province. Say, if a province is selected in the first combo box, the second combo must only show Districts in that province (in first combo).
    Example, If a province is Bougainville, then the next combo will show list of 3 province bougainville has (South, North, Central).'

    I have tried but its not working,

    I NEED SOME TIPS AND HOW TO DO THIS.

    Help

  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,643
    How about

    http://www.baldyweb.com/CascadingCombo.htm

    saying you tried and it's not working is meaningless without showing exactly what you tried and what exactly went wrong.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    byulogia@gmail.com is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2019
    Location
    Papua New Guinea
    Posts
    22
    I tried first by linking tables, but links are not working.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    I'm confused. Trouble linking tables seems like a completely different issue.
    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. Combo Box list based on another combo list
    By byulogia@gmail.com in forum Forms
    Replies: 1
    Last Post: 03-07-2019, 05:29 PM
  2. Replies: 3
    Last Post: 06-16-2018, 11:12 PM
  3. Replies: 2
    Last Post: 03-07-2018, 11:00 PM
  4. Replies: 7
    Last Post: 03-07-2017, 03:01 PM
  5. Replies: 4
    Last Post: 10-21-2013, 11:06 AM

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