menu item to preselect items for dynamic menu

[btween]

I have a recordset rsprods that I want to presort using a menu item. For example if the database contains eyeglasses and there are different categories, If I select sunglasses on the first menu item, the second menu item would be populated only with the items in the database that have sunglasses under the column heading category. Anybody know how this can be done?
Thanks in advance
Here is the code fior the dynamic recordset with all the items populating a menu:


<select name=&quot;name&quot;>
<%
While (NOT rsProds.EOF)
%>
<option value=&quot;<%=(rsProds.Fields.Item(&quot;Name&quot.Value)%>&quot; ><%=(rsProds.Fields.Item(&quot;Name&quot.Value)%></option>
<%
rsProds.MoveNext()
Wend
If (rsProds.CursorType > 0) Then
rsProds.MoveFirst
Else
rsProds.Requery
End If
%>
</select>

 

[vbkris]

o.k this is a question for ASP forum, but i will still answer it, in ur above dropdown u have to include a javascript that will resubmit ur form and then populate ur second dropdown, try a search in the ASP forum for dynamic dropdown or something...

Known is handfull, Unknown is worldfull