Hello,
I want to populate a selectbox from the contents of a Access Table
This is my code
It populates but does not allow me to select and go
I want to populate a selectbox from the contents of a Access Table
This is my code
Code:
<%@ LANGUAGE="JScript"%>
<HTML>
<HEAD>
<TITLE>View PO Numbers</TITLE>
</HEAD>
<%
var recordSet = Server.CreateObject("ADODB.RecordSet");
recordSet.Open("SELECT * from Data","DSN=POnum");
%>
<head>
<title>Make a choice to define your search</title>
</head>
<body>
<div>
Choose Vendor
<form action="SearchView.asp" method="get" >
<select size="8" name="Search1" multiple style="width:1000px" width="250" >
<option value="">
<%
while(!recordSet.EOF)
{
%>
<%=recordSet("Vendor")%>
<%
recordSet.MoveNext();
}
%>
</option>
<option value="">12 Marshland, LLC</option>
</select>
<br />
<input type="submit" value="Continue" /> <input type="reset">
</form>
</div>
<div>
<%
while(!recordSet.EOF)
{
%>
<%=recordSet("Vendor")%>
<%
recordSet.MoveNext();
}
%>
</div>
</body>
</html>It populates but does not allow me to select and go
