Cascading Combo box to three levels

[shaz0503]

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

 

[tina]

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