Drop Down Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an expense list database. One field in [catagories] one field is
[despriction]

Each catagory has a list of possible descriptions associated with it IE if
Office supplies is chosen as the catagory then office max or hoopaco office
supply could be possible choices for the description.

I have drop down boxes for both fields. I would like to filter choices for
the drop down to the appropiate descriptions based on the catagory chosen.

IE if office supplies is chosen as the catagory only descriptions related to
office supplies would appear in the description drop down.

Any suggestions as to how to accomplish this?
 
Stefan,
You need to use the value in first Categories combobox as a filter in the
query behind the second Description combobox.
In the query behind the Description, your Category field should have a
Criteria of...
= Me.Category
That will filter the values returned by the Description so that they
always correspond to Category.
(Also, you'll need to requery Description on the AfterUpdate event of
Category)
hth
Al Camp
 
Back
Top