using row source

[letsomebodyknow]

Hey

I have two list box.

the first box give the names of states.
The secound box uses the state name from box one. Then displays all colleges within that state.

This is an event. I am trying to get a grasp on the difference bettween DAO and ADO before coding.

At this point I like to know how to set the row source of the secound list box choice.

If you have the time to provide the compleet VBA; I will enjoy it.


Thanks a bunch
tom

 

[pbaldy]

If you search here for cascading combo boxes, you'll find numerous examples of techniques, which would be no different for listboxes (unless the first one is multiselect).

 

[letsomebodyknow]

not multi select

If this an event will it that I will have code it?

Thanks
Tom