conditional lists in access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Andy B
    New Member
    • Feb 2010
    • 1

    conditional lists in access

    Be easy on me if this is too easy a question, but this is my first forum. I saw a forum in here and didn't know what OS it applied to. In Access 2007, I would like to create a combo box which displays choices based off of a previous entry. The example used earlier was if you select a manufacturer, then the second list would only give you the list of products that manufacturer offers. Is there an easy way to do this without having a phD in SQL and Visual basics?
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Well, it's going to take some VBA code, but if you want to do any serious Access development you're going to have to bite the bullet and learn to code.

    The concept is called "cascading comboboxes" although the same applies to listboxes, as well. Here's a nice tutorial on the subject by one of our past members, Rabbit:



    Welcome to Bytes!

    Linq ;0)>

    Comment

    Working...