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

  • Thread starter Thread starter Joanne
  • Start date Start date
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.
 
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...
 
Back
Top