Im using the onchange event for a dropdown list to change SQL statements based on the index of that dropdown chosen. For example I have a function like this for my onchange event of the drop down list.
declare connection ...
SQL = "Select * FROM
Field1 = ' "%>index<%" ' "
make connection with SQL statement...