combo boxes

[b9791]

I have a form with two combo boxes that are related to each other. The first is a category list and the second is the subcategories. How do I make the subcategories drop down only display the entries that are related to the category drop down?

Thanks in advance

 

[RichMorrison]

Search the forums for
"cascading combo boxes".

This is a very popular topic.

RichM

 

[Vegard]

I've already searched the forum for cascading combo boxes.. I dream about cascading combo boxes, but, I can't add new names into the second combo box.

I don't think that is written in any other posts..

Thanks.

Vegard
Vegard_ingdahl@zapo.net

 

[Alexandre]

Do a search on 'Not in List'.
However, you may have to foresee further checking in your NotInList Event in the case of cascading combos since you probably want to avoid situations like the following one:


User selects the value: '1' in Combo1

Combo2 is based on the table:
CriteriaField___ValueField
1____________a
1____________b
1____________c
1____________d
2____________e
2____________f

User wants to enter "e" in combo 2, that is not in the subset list displayed by combo2 (which is a,b,c,d, when 1 is selected in Combo1)

The NotInList event is triggered but you do not want to let the user register "e" as a new item in the underlying table since it does exist already, but is associated to value 2. You would rather have the user choose value 2 in combo1....
You may want to check for such situation to display a wanrning message and abort the NotInList event.