I've recently created a drop-down list that gets populated by the information I wrote in my SQL statement. What I want to do is pass my SQL a number that is hardcoded in my drop-down list and then have the SQL read that number, get the appropriate table data and then put it in my drop-down list. I also would prefer to have this drop-down list call a function in another .asp page so that the same SQL can be used by other fields on other .asp pages that have a different number that needs to be called. Hope this makes sense. Any help would be greatly appreciated!!