combo boxes

[elios11583]

i have two combo box in 2 different forms.

the first combo (material) in the main form and the second combo(submaterial) in the nested subform.
i need to show the list of the second combo"submaterial" box based on the selection of the first one"material"
the rowsource of the "material" combobox is in table "type"
and the rowsources for the "submaterial" combobox is in the table "subtype".
how to do it and how the tables should be related?
thx

 

[Fernando]

Try to change the "subtype" combobox rowsource to:

SELECT submaterial FROM subtype WHERE material = forms!YourFormName!YourComboboxname

And whats the structure of ur tables?

 

[ajetrumpet]

the first combo (material) in the main form and the second combo(submaterial) in the nested subform.
i need to show the list of the second combo"submaterial" box based on the selection of the first one"material"
the rowsource of the "material" combobox is in table "type"
and the rowsources for the "submaterial" combobox is in the table "subtype".
how to do it and how the tables should be related?
thx

You might be able to get an idea from this...

http://www.access-programmers.co.uk/forums/showthread.php?t=134735

A one-to-many relationship is what you need.