I am wondering and not sure if it is possible but, does anybody know if it is possible to have a drown down box on a form page and then on a results page have a drop down box appear that would refine a search result but only give options in the drop down box that would be relevant to the original choice selected in the form pages drop down box?

Thanks

Hi. Is what you were asking something like this: http://daniweb.com/techtalkforums/thread25510.html

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...