Results 1 to 4 of 4
  1. #1
    karl1971 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    8

    display a list of values based on user input

    specifically, I am writing a database about cars. One of my fields will be carMake, and it drops down all the makes of cars (i.e Ford, Chevy, Pontiac, etc.). Another field is the model, and there are a lot of models. I want to be able to see a drop down list that matches the make of vehicle that is selected. So if I select FORD from the list box, then when I pull the list down in the model field, only Ford cars are displayed. I was reading in my access books, and I think that a pivot table might help me do this, but upon reading about them, I am not so sure. Can anybody point me in the right direction? Thank you very much

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Welcome to the forum!

    If your tables are properly structured, you will need to look at the cascading combo boxes approach where the first combo box is used to filter the data in the second combo box. The second combo box would filter the 3rd and so on. This site has an example of cascading combo boxes

  3. #3
    karl1971 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    8
    hmm, Cascading combo boxes of course! lol thanks for the welcome and the lead. I am going to figure this out. Thanks for your help.

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You're welcome. Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-28-2011, 06:40 PM
  2. Display user input as Asterisk
    By 95DSM in forum Programming
    Replies: 2
    Last Post: 12-20-2010, 12:22 PM
  3. Replies: 3
    Last Post: 08-25-2010, 09:03 AM
  4. Replies: 2
    Last Post: 06-17-2010, 04:15 PM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 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