combobox generate another combobox

[white_flag]

good morning :)

I would like to know if it is possible to create an combobox based on selection from another combobox. example: I have one combo(1) and wen I choose something from that combo to generate another combo(2) that was not existing and so one combo(2) to generate combo(3) till 5.

can someone help me with an example.
many thanks

[OBP]

Yes, it is quite common to do something similar to this, although it is not normal to "create" the combos at runtime.
You would normally create all the combos at design time.
The way to base one combo on the Selection of another combo is to filter the SQL Row Source of the second combo with the first combo using the
forms![formname]![comboname]
where formname is the name of the form and comboname is the first combo's name.

[OBP]

See this for an example.
http://forums.techguy.org/business-applications/876033-access-2003-basing-one-combo.html

[white_flag]

thx. OBP..but, I saw that I putted in the wrong forum. Can some one from administrators to move this, to the excel forum. thank you

[white_flag]

ok ..I putted this thread to excel ..please, one of the admin delete this thread. thank you