Cascading combo boxes advanced.

[didi]

Hi guys,

I was just wondering if any of you knew how to split a selection from
a combo box across a set of multiple combo boxes. This is because i
want the feedback topics that have been associated with a course, that
have their own selections to be made from each topic, to be populated
into the combo boxes once the course has been selected.

I.E.
If course dissertation, is selected that has feedback topics,
presentation and knowledge associated with it, then each feedback
topic will appear in a separate drop down box containing all it's
feedback options.

If anyone could help it would be gratefully received.

Many Thanks

Didi.

 

[Ron2006]

Something like this:


Query for first Combo

Course
SubTopic1
SubTopic2


Afterupdate event of combobox1

me.combobox2 = me.combobox1.column(1)
me.combobox3 = me.combobox1.column(2)



==============================
The column counts in a combobox query are numbered from 0 to n,
so second column is subscript 1


Ron