Well I guess you should work on one thing at a time. You have a few issues:
1) Your list isn't populated correctly
2) the selections don't stick
3) the filter doesn't refresh
is that correct?
1) is probably an issue with your recordset query. Your list is set up to return the results from that query, so if the results are wrong, then the query in the recordset is probably wrong.
2) Not sure what you want to be selected. You should remove 'selected="selected"' from the first option, it would keep other options from ever being selected.
3) Might be an issue with your trigger that you are using for your filter. How are you filtering it? What is not resetting exactly?
Did this help? Tips are appreciated...
