multiple choices from a table

[Leverlad]

Using 4 combo boxes I want to be able to choose from selective dropdown pick-lists for dedicated info.

column 1 column 2 column 3 column 4
Breakdown Machine 1 Area1 type1
Breakdown Machine 1 Area1 type2
Breakdown Machine 1 Area2 type3
Breakdown Machine 1 Area2 type4
Breakdown Machine 1 Area3 type5
Breakdown Machine 1 Area3 type6
Minor stop Machine 2 Area2 type7
Minor stop Machine 2 Area3 type8
Minor stop Machine 2 Area3 type9

By selecting Breakdown from column 1 I can then choose machine 1 from the drop-down list in column 2 which will then give me a choice from column 3 which will then give me a choice from column 4.

I hope that somebody can help me with this problem

 

[MStef]

Hello Leverlad!
Look at "Demo4CboxesA97.mdb"
(MStef alias Štef)

 

[Leverlad]

MStef
Thanks for the prompt and very useful reply this was exactly what I was looking for.

 

[Benny1973]

Multiple Combo Boxes - can't find the answer in the forums

I am wanting a Combo Box to display Work Type
Work Type has 18 types in the drop down list. When the Work Type is chosen I want to go to the next Combo Box that lists Work Codes relating to the Work Type. EG Work Type AIR is chosen and 9 Work Codes appear. You can select this and it will be displayed in a sub form. I have seen some great Databases in here but none that show that more than one selection can be made and displayed in the sub form.

I hope someone has a sample in a database that I can use, many thanks