Hi,
I have been searching through msdn and unfortunately found that the on_click event doesn't apply to drop down lists, so I was wondering if someone had an alternative for my problem.

Basically, I populate a list box by returning a recordset from a DB, and building a string of </option .. values as

while not oRs_TypeOFBusiness.EOF
Combo_tob = Combo_tob & "<option selected value=" & oRs_TypeOfBusiness("TypeOfBusiness") & ">" & oRs_TypeofBusiness("TypeOfBusiness") & "</option>"
ors_Typeofbusiness.MoveNext
wend


However, what I require is that when a customer clicks on an option in the list box, I want to fire an event that will cause a further selection based on the user selection, and populate another list box as a result.

For example if they clicked dogs from the list

dogs
cats
mice

I want to select a recordset from a database based on the word "dog" as a criteria of the search.


Any help appreciated.

Lenin