How do you retrieve data when selecting a value from a drop down list?

[Gurpreet22]

I have designed a web form, which has a drop down list. What i would like to do is when a user selects a value from the drop down list and submits the form, the user is redirected to the next page, which provides them with further infomation on the selection they have made. I am using asp and an access database. If any one can help it will be greatly appreciated.
Thank you

[hini]

this is a simple code that you can test, name the file "thepage.asp"

 
<%
text1 = request("mySelect")
if text1 <> "" then response.write("you selected " & text1)
%>
 
<form method="post" action="thepage.asp">
<select name="mySelect">
<option>first</option>
<option>second</option>
</select>
<input type="submit" value=" Submit Your Choice ">
</form>
 

you may put the first lines in another file, in this case you need to change the "action" attribute of the form to the new asp page.

and you can put a query in the new page that selects additional information about the selected entry.

[padmakar]

you can catch values via javascript from a select value and transfer the selected value to another page using querystring
var myselect=document.getelementbyid("select")

get the value selected by:
myselect[myselect.options.selectedIndex].value

pass this value in querystring

[Dipti Singh]

on the second page u can simply get the value what the user selected.

val=request.form("xxxx")

in the page page your select statements will be like this:

<select name="xxxx">
<option name="firstoption" value="1">some text</option>
<option name="secondoption" value="2">other text</option>
</select>

the above request.form.... will give the selected value to val variable.
eg: 1 or 2

now this value can be checked in SQL query.

I have designed a web form, which has a drop down list. What i would like to do is when a user selects a value from the drop down list and submits the form, the user is redirected to the next page, which provides them with further infomation on the selection they have made. I am using asp and an access database. If any one can help it will be greatly appreciated.
Thank you