I'm trying to make my button go to Task2-Step2.asp. What am I missing?
[code]
<html>
<head>
<title>Assignment Twelve</title>
<link rel=stylesheet type='text/css' href='MyStyle.css'>
</head>
<!--#include file="MyInfo.asp" -->
<body>
<h2>Kendall's Task 2</h2>
<%
' Open connection to back-end SQL Server database
Set conn=Server.CreateObject("ADODB.Connection")
conn.CommandTimeout=15
conn.ConnectionTimeout=15
conn.Open BackEnd
' Begin input form
Response.Write("<form action='Task2-Step2.asp' method='post'>")
' Open recordset
sql="SELECT Distinct College FROM tblDiscipline INNER JOIN tblStudent ON tblDiscipline.DID=tblStudent.Major ORDER BY College"
Set rst=Server.CreateObject("ADODB.Recordset")
rst.Open sql, conn
' Display colleges
Response.Write("<h3>College</h3>")
Response.Write("<select name='College' style='width:150px'>")
Response.Write("<option value='College' selected></option>")
Do Until rst.EOF
Response.Write("<option value='" & rst("College") & "'>" & rst("College") & "</option>")
rst.MoveNext
Loop
Response.Write("</select>")
' Display button
Response.Write("<br><br>")
Response.Write("<input type='submit' value='Students'")
' End input form
Response.Write("</form>")
' Close recordset
rst.Close
Set rst=Nothing
' Close database connection
conn.Close
Set conn=Nothing
%>
</body>
</html>