I have been working on a web page to enter city and state for a user. I have tables in my SQL database that have all 50 states and all the cities by state. I am stuck on how to filter the city select option based on the state selected.
Here is test page that will be moved to the main page after it works.
http://processsolution.net/selectstate.asp?User_ID=1
State Select
<option<% If rs2("StateID")=StateID Then Response.write " selected " %> value="<%=rs2("StateID")%>" onselect="SetState()"><%=rs2("State")%></option>
Select City Code
<tr><td>City: </td>
<td><select size="1" name="ID">
<%
Set Conn2 = Server.CreateObject("ADODB.Connection")
Conn2.Open CONNECTSTRING
Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL2 = "SELECT * FROM tblCitiesByStates WHERE [State Name]=" & txtstate & "ORDER BY [City Name]"
rs2.Open SQL2, Conn2
While Not rs2.EOF
%>
<option
<% If rs2("ID")=StateID Then Response.write " selected " %> value="<%=rs2("ID")%>"><%=rs2("City Name")%>
</option>
<%
rs2.MoveNext
Wend
rs2.Close
Set rs2 = Nothing
Conn2.Close
Set Conn2 = Nothing
%>
</select></td></tr>