dropdown search not working

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   All I want is get a search criteria from the kiser table into a dropdown box, select a location from that list and send them to searchResults.asp.
So far, when I run this form called searchForm.asp, the page is blank.
Can you please, please help!

Here the entire code for searchForm.asp

<%
Set myConn=Server.CreateObject("ADODB.Connection")
myConn.open("panoa")
SQLstr = "SELECT * FROM kiser WHERE loca IS NOT NULL ORDER BY loca"
Set RS = myConn.Execute (SQLstr)
%>
<html>
<head>
 <title Search For Address</title>
</head>
<body bgcolor="ffffff">
 <center><h2> Search For a Location:</h2>
 <form="selectRecordForm" action="SearchResults.asp" method="post">
  <table>
   <tr>
      <td>Location </td>
   </tr>
   <tr>
    <td>
       <select name="selLocation">
       <%
        Do while NOT RS.EOF
       %>
       <option value='<%=RS("loca")%>'
       <% if (RS("loca") = "Marsh Creek") Then
       Response.Write("SELECTED")
       End If%>>
       <%=RS("loca")%>
       <%
       RS.MoveNext
       Loop
       %>
       </select>
       </td>
       </tr>
       <tr>
        <td>
         <input type="button" name="cmdback" value="Back" onClick="history.go(-1)">
         <input type="reset" name="cmdreset" value="Reset">
        </td>
        <td align="center">
        <input type="submit" name="cmdsubmit" value="Search">
        </td>
       </tr>
       </table>
       </form>
       </center>
       <%
        RS.close
        myConn.close
       %>
       </body>
       </h