populate a combo box based upon a selection in another combox box

Posted on 2012-08-31
Last Modified: 2012-08-31
Attached is the DB

I have a form : SMSItems

I have 2 combo box,

There is a table: DEPENDENCY
Based on the type selected , I want the DEPENDENCY combo box to populate

I tried many way , couldn't get the corresponding list for the type....
Please advice asap
Question by:mercybthomas74
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Cascading Lists...
    Here is one very popular link:
    LVL 39

    Accepted Solution

    And this is example, based on your sample. I've also changed fields in table from text to number (normally you should not store text fields, if you can store ID)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now