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?

[Cander]

This must be possible, but How?

No, its not possible. You use the recordset name being passed as the basis for a new Select statement to create the recordset object.

[modernthinker]

so there's now way to get the details from a form and use that to to select which recordset i want?

[Cander]

not like that ..no. Besides from what you are saying, you are persisting recordsets which you should NOT be doing.

In other words you shouldnt be selecting recordsets from a drop down. You should be selecting string representations of a recordset you want to open. Then detect which was selected by using if statements and opening a recordset based on what was choosen.

[JoshT]

It might be possible to use the Eval function to do what you want, but I agree with Cander in that there's better ways to do it.

http://msdn.microsoft.com/library/de.../vsfcteval.asp