try this:
on change of the first combo/list submit the form and pass the value of the combo to the query to fetch the records satisfying this value....
then populate the second combo accordingly based on the recordset from the second query
hope this helps...