access 2010

I want to make a string of combo boxes to change each other based on the previous one.

I am working on a character creation database: Hair type

I want the user to choose the Color and the length box pops up
then the length box selection pops up and changes the texture box
then the texture box pops up and changes the volume box
then the volume box pops up and changes the style box

example:
length class = 2 --> shows texture box, volume box, style box: all display is class 2

The texture, length, volume, style boxes have Category Name (i.e. Length) and Class Numbers (i.e. Class 1, 2, 3).

I've tried to find or create code that will do what i want but no one seems to know how to do this or even if it is possible (not even my professor).

please let me know if you have any ideas (preferably full code if you've got it)

thanks!

dear Selene,
i used this type of possibilities, but never through code.
I created (in my case) 4 comboboxes in a form
I my case i had a table with number in 8 positions (2 by 2), so i had 4 "classes"
In fact it was a table on the classification of economic activity hosted by our Central Bank
In the first cbo i made a selection on the 2 first positions: this became the "value" of my first cbo ( => cboFirst.value eg 02 = transport sector)

My second box had a "preselection" of my first (cboFirst.Value) and show me only the values 02.00 trhrough 02.99 you choose eg "roadtransport"
But you will never find here something in the agricultural sector....

and so on for the other 2
I think it should be possible to organise your application with this ideas

Marc

how did you do that without code?

can you do a step by step how for me?

Hi Selene,
I rebuilt (a part of) an former application I had and made some "comments" to it, step by step, so that you can understand (I hope) the idea behind this way of approach.
Only there is a word-doc, an excel-file and an access-database involved.
If you are interested, please give me an email adress where I can send the whole stuff (by preference a Gmail, because they don't blockoff access files)

My address : [email protected]
regards
Marc

i just sent you an email with my main email addresses and it was named:

"combo boxes coding/examples wrox"

i'll get back to you with my results once i get the stuff you offered.

thanks