Cascading Combo box to three levels

  • Thread starter Thread starter shaz0503
  • Start date Start date
S

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
 
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
 
Back
Top