Submit form by clicking on link

[jasonhuibers]

I have a list that is dynamically populated by a sql query. I want to be able to click on an item from the list and return the RecordNumber column from the query..

 

[foxbox]

?!
in pseudo code:

<select>
<%
cSQL = "SELECT id,description from myTabel"
rs.open cSQL, conn
do while not rs.eof
 response.write "<option value=" & rs(0) & _
   ">" & rs(1) 
 rs.movenext
loop
%>
</select>

? but you want something else ? any code already?