Combo boxes

[tselie115]

Hello i have two related tables types and subtypes with one to many relationship id primary key.n i hve 2 combo boxes type in form1 n subtype in subform1.how to select the list of combo subtype based on the selection of combo type based on id?

 

[maxmangion]

search this forum for cascading combo boxes.

 

[tselie115]

still not working.
comboboxes are in different forms that are subforms.
tables seeding the combo boxes have one to many relationship!

 

[maxmangion]

are you sure you are referencing the combos correctly.

check out this link. It shows you how you should be referencing controls when they are on forms/subforms.

 

[tselie115]

the structure is like
Main>Products>Inventory Transactions>SUBMATERIALS
the first combo on Products is type
the second combo on SUBMATERIALS is material.
how to set the rowsource of material combo box on the afterupdate event of type combobox