Contents of one drop down list based on the contents of another li

J

Joanne

Hello,
I have a drop down list in a form that has all of the software companies we
use: Microsoft, Adobe, etc. Then in another fields I want to have the
specific software that we install from that company. So if I choose
Microsoft in the first drop down, I don't want to see "Acrobat" listed in the
second drop down. Could someone tell me how to code this? I've posted this
question a few times but I don't seem to be able to get an answer. Thanks.
 
D

Daryl S

Joanne -

You need an AfterUpdate event in your first drop-down list. In this code
you will change the recordsource property for the second drop-down list to be
a query that only shows the products for the selected software company.

Search for "Cascading" in the help for more details...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enable 2 fields based on the drop down selection of another field 2
Formatting combo box drop-down list 1
Excel Excel: How do I put a formula in a drop down list 11
Filtered Drop Down Menu Based on Previous Drop Down Selection 1
Label based on drop-down box selection 3
drop down box issues 1
Combo Box Drop-down list is based on specific data 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Top