cwfontan
01-16-2008, 07:26 PM
i need a little help I have done this before and cannot get it going...
I need a dynamic list menu and when an option selected it updated the recordset filter..
EDIT*** this does work if i take the onchange out and ad a submit button.. its just the onchange or onclick that I am screwing up somehow..
here is var
<%
Dim rs_faq__MMColParam
rs_faq__MMColParam = "1"
If (Request.Form("topic") <> "") Then
rs_faq__MMColParam = Request.Form("topic")
End If
%>
here is the form
<form name="form1" method="post" action="" >
<select name="topic" id="topic" onChange="reload" >
<%
While (NOT Recordset1.EOF)
%>
<option value="<%=(Recordset1.Fields.Item("uid").Value)%>"><%=(Recordset1.Fields.Item("topic").Value)%></option>
<%
Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
%>
</select>
</form>
I need a dynamic list menu and when an option selected it updated the recordset filter..
EDIT*** this does work if i take the onchange out and ad a submit button.. its just the onchange or onclick that I am screwing up somehow..
here is var
<%
Dim rs_faq__MMColParam
rs_faq__MMColParam = "1"
If (Request.Form("topic") <> "") Then
rs_faq__MMColParam = Request.Form("topic")
End If
%>
here is the form
<form name="form1" method="post" action="" >
<select name="topic" id="topic" onChange="reload" >
<%
While (NOT Recordset1.EOF)
%>
<option value="<%=(Recordset1.Fields.Item("uid").Value)%>"><%=(Recordset1.Fields.Item("topic").Value)%></option>
<%
Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
%>
</select>
</form>