cascading combos and list selection

[Guest]

i think i have managed to build a version of cascading combo boxes. i have
three combo boxs that select the values for theme, region, and industry. now
i have list box that displays the variables available for any combination of
criteria, however, it will not automatically refresh. it only displays
different info when switched from design view to form view. is it possible
to solve this without complicated codes?

also, i would like a box displaying years available for data when a
particular variable is selected in the list. how to?

 

[Keith Leslein]

If this ListBox is based on the Combo criteria you could use the
Requery feature on the AfterUpdate Event of the Final ComboBox.

Me.ListBox.requery

 

[Guest]

Thanks Keith. I assume that to do this, you click properties of the combo
box, then AfterUpdate, then code builder, then just type in what you told me,
inserting the names of the combo box of course.

I tried it, but nothing happened. The list box remained populated by the
first query.

 

[Guest]

sorry about the last post, i tried it again but with the name of the listbox
in the requery not the combo box and it worked! thanks again