Hi,
I created a page the has drop menus based on database recordsets that filter each other . The only problem i run into is keeping the only problem i'm having is holding the view state of the first dropmenu after it reloads. I've tried cookies, session states...am i doing something wrong?? this is my code for the cookies and the form:
<% select=request.cookies("select")
if select="false"
then end if
%>
<form name="form1" method="post" action="" >
<p> Make
<select name="select" id="select" value="select">
<%
While (NOT Recordset1.EOF)
%>
<option value="<%=(Recordset1.Fields.Item("VechicleMakeID").Value)%>"><%=(Recordset1.Fields.Item("VechicleMake").Value)%></option>
<%
Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
%>
</select>
</p>
<p>Model
<select name="select2" id="select2">
<%
While (NOT Recordset2.EOF)
%>
<option value="<%=(Recordset2.Fields.Item("ModelID").Value)%>"><%=(Recordset2.Fields.Item("Model").Value)%></option>
<%
Recordset2.MoveNext()
Wend
If (Recordset2.CursorType > 0) Then
Recordset2.MoveFirst
Else
Recordset2.Requery
End If
%>
</select>
</p>
<p>parts
<select name="select3">
</select>
</p>
<p>
<input type="submit" name="Submit" value="Continue" >
</p>
</form>
<%
Response.cookies("select")=select
%>
Any Ideas??