I am creating a form to specifiy several properties for three product
models.
They all share some basic properties, but the choices for each property
are different based on the model.
For example, for the color property.
Model A: red, green, yellow
Model B: blue, orange, purple
Model C: clear, black, white

Is it possible to select one of the three models listed (A, B, C) using
a Combo Box (Control Form) and based on the model, select the list of
colors that the Color Combo Box will use?

In other words, using the Model Combo Box, the user will first select
one of the three listed models, and based on this selection, the Color
Combo Box will 'look' at the proper list from three possible lists to
offer the choices.

I don't know if I explained what I want to do clealry - please, let me
know.

(FWIF, in the real application there are over 30 characteristics.)

Thanks

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=533283