<form id="form1" name="form1" method="post" action="">
<select name="select" id="select" onChange="document.form1.submit()">
In this case, you would so much be using dynamic drop downs. Since the form is posting each time the select list is changed, you can filter the recordset that populates the child list on the information submitted by the parent list. These two lists can also be used to filter the results recordset.