Move to record and not filter to record
<p>Currently my dropdownlist returns a value that I use in a SQL WHERE clause to return a result set.  I would like to be able to just move to the selected record as oppose to filtering the whole set.  When I filter I am no longer able to page through the records (I can only choose another search selection from the dropdownlist because there are no other records to page through - I would like to use both).  What is the best way to achieve this?</p>