Combo Box

[Hirameck]

Hi!
I need to ad three combo boxes wich are linked to another to a form.If your select first box the second box should automatically be linked.

e.g. First box: Second box: Third box:
- House ------- Rooms ---------Blue
---------White
---------Red

------- Roof ---------tiled
---------painted
- Garden------- Flowers---------?
---------?
THANKS

 

[jason246day]

In the OnClick event of the second box you should have:

If firstbox = house Then
secondbox.RowSource = "Put a query here"
Elseif firstbox = garden Then
secondbox.RowSource = "Put another query here"
End If

You can do the same type of thing of the third box too.