This must be possible, but How?

[modernthinker]

I have this code :

<%
do while not RsNewham.eof
%>
<p><%=RsNewham("fieldname2")%></p>
<p><%=RsNewham("fieldname2")%> </p>
<%
RsNewham.movenext
Loop
%>

I can loop through my fields and display the contents that are held in a access DB. The problem is this. I have several recordsets. The user selects which one he wants to search through using a drop down. so i want the code to replace 'RsNewham' with the one that is selected.

To do this i wrote :

<%
Dim strSelectedChoice 
strSelectedhoice = "Rs"+Request.form("select")

do while not StrSelectedChoice.EOF
%>
<p><%=StrSelectedChoice("Category")%></p>
<p><%=StrSelectedChoice("type_of_org")%> </p>
<%
StrSelectedChoice.movenext
Loop

My above code doesn't work but is it possible to insert the
recordset name from a form?