Here is a hint:
the page category.asp uses Request.Forms("Name of select
box").Value to find which one was selected
good luck
<%
Set DbObj = Server.CreateObject("ADODB.Connection")
DbObj.Open "DSN=Music;USR=;PSW=;"
SQL = "SELECT * FROM Categories"
Set records = DbObj.Execute(SQL)
records.MoveFirst
%>
<body bgcolor="wheat" onload="document.forms[0].reset()">
<form action="category.asp" Method="post">
<p>Open Which Catergory?</p>
<select name="cat" size="1">
<% WHILE NOT records.EOF %>
<option value="<%= records.Fields("CID").Value %>"><%=
records.Fields("CategoryName").Value %></option>
<% records.MoveNext %>
<% WEND %>
</select>
<br>
<input type="submit" value="View Bands"><input type="Reset">
</form>
<%
DbObj.close
SET DbObj = Nothing
%>