Hopefully I have understood your problem...
You are currently showing a table of results?
1..When you get your records are you pulling a unique identifyer?
2..Make an element in each row clickable (an icon, text or whatever)
3..In the link pass the unique identifyer as a QueryString value.
Post the link to the same page. My identifyer is called ID and the value is held in a record set called rs Eg:
<a href="pageName.asp?Id=<%= rs(0) %>">Click me</a>
4.When this link is clicked the page will reload (passing this querystring) At the top of your page I would do something like:
IF request.querystring("id") <> "" then
'user has clicked the link so run the sql showing the selected record only
'run the sql here to pull all records (default page view)
NOTE : Use the same recordSet name for both queries. This way you only need one loop on your page. It will show all records, or just the one asked for when the user clicks the link
BTW : It doesnt matter what DB you are using, this theory will work either way. From reading your post the connection and the query to show all records is not part of your problem?
Wind is your friend