Cascading Combo box to three levels

All

I have borrowed code from the web and it works wonderfully in developing
cascading combo to 2 levels - what I need is a macro to go to a third level.

the code I am using now is

Private Sub cboCountry_AfterUpdate()
On Error Resume Next
Select Case cboCountry.Value
Case "DevelopmentPlanning"
cboQuery.RowSource = "tblWebDevelopment"

I can use this for all option at the first and second level but want an
additional combo box

first level selection - DevelopmentPlanning
second level selection is Web Development and now need to add next level
options
(busilding a budget for example)

any assistance or 'you can't do' is appreciated

rgds

Shaz

well, the code runs in the first combobox control's AfterUpdate event
procedure, to set the RowSource for the second combobox control, correct?
and now you want to set the RowSource of a third combobox control, when a
selection is made in the second combobox, correct? if so, just add similar
code to the AfterUpdate event procedure of the second combobox control. or
am i missing something here?

hth


"shaz0503" wrote in message
...
All

I have borrowed code from the web and it works wonderfully in developing
cascading combo to 2 levels - what I need is a macro to go to a third
level.

the code I am using now is

Private Sub cboCountry_AfterUpdate()
On Error Resume Next
Select Case cboCountry.Value
Case "DevelopmentPlanning"
cboQuery.RowSource = "tblWebDevelopment"

I can use this for all option at the first and second level but want an
additional combo box

first level selection - DevelopmentPlanning
second level selection is Web Development and now need to add next level
options
(busilding a budget for example)

any assistance or 'you can't do' is appreciated

rgds

Shaz