Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Thanked 0 Times in 0 Posts

    Cascading dropdown menus in a form (Access XP)

    I have a database with essentially four tables. Two of the tables contain only one field each and are titled LocationOfOb and DescriptionOfOb. These two tables are fixed lists that feed into a LocationDescriptionOfOb table. The LocationDescriptionOfOb table matches only certain descriptions with a specific location. Basically, a location can have multiple descriptions but not all the descriptions are allowed for all the locations. Hopefully this makes sense.

    The final table captures the Observation (Observation) as a text field and then has a LocationOfOb and a DescriptionOfOb field to allow someone to categorized the observation.

    What I want is a form that allows a user to type in the observation and then has a cascading dropdown menu to allow them to pick a location and the proper description based on my LocationDescription table limitations. Combo menus don't seem to have the capability to have multiple cascading parent and child dropdown menus. Is there a way to do this?

    I tried using two separate combo boxes but the child box (DescriptionOfOb) does not seem to update properly after selecting the LocationOfOb from the list. I was thinking that a set of cascading dropdown menus would be more user friendly anyway.

    Please note that I don't have any VB coding experience so please keep everything as basic as possible but I'm willing to give anything a try. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Cascading dropdown menus in a form (Access XP)

    See MSKB article How to Synchronize Two Combo Boxes on a Form; it also contains a link from which you can download a very useful demo database with a working example. You can also search this forum for cascading combo boxes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts