[williega]

Hello,

Can anybody point me to a HTML/ASP search form out there that I can edit to allow multiple pull down menues to search my access db and display results? Sample form where user selects:

Pull Down1
City:
New York
Tulsa
San Diego

Pull Down2
State:
NY
OK
CA

Pull Down3
Cuisine:
Italian
American
Japanese

I found this one but it does not help me.
http://www.activeserverpages.com/glenncook/

thx
Willie

[jha]

you have to use onchange event
like onChange="this.form.submit();
Try

<tr><td>field1</td>
   <th width=5%>:</th>
<td>
<% Set RS3=con.Execute("select *from table where field='"&field1&"'") %>
        <select Id="field1" Name="field1" onChange="this.form.submit();">
        <option value="ALL">[Select]</option>
            <% while not rs3.eof %>
        <option value=<%=rs3("field1")%>><%=rs3("field1")%></option>
            <%
            rs3.movenext
            wend
            Rs3.close
            session("field1")=Request.Form("field1")
            if SEssion("field1")<>"" then
            
           Set RS3=con.Execute("select *from table where deptcode='"&session("field1")&"'")   %>
        <option value=<%=rs3("field1")%> selected ><%=rs3("field1")%></option>
         <%end if%> 
         </select></td>
         </tr>
         
           <tr>
    <td width=15%> <font  color="#0000FF"><b>Field2 </td>
    <th width=5%>:</th>
    <td>
<%  
            Set RS=CON.Execute("select * from table where field='"&session("field1")&"'" )
 
            %>
 
        <select Id="Sect" Name="sect" onChange="this.form.submit();">
        <option value="ALL">[Select field2]</option>
            <% while not rs.eof %>
        <option value=<%=rs("field2")%> ><%=rs("field2")%></option>
        </option>
            <%
            rs.movenext
            wend
            Rs.close
            session("field2")=Request.Form("field2")
            if SEssion("field1")<>"" then
            IF session("field2")<>"ALL" THEN
            
           Set RS=con.Execute("select *from table where  field='"&session("field2")&"' ")         %>
        <option value=<%=rs("field2")%> selected ><%=rs("field2")%></option>
         <%
         end if
         end if
            %>  
         </select></td>
         </tr> 

let us know it help you ............
Regards
jha