list box after submit

[skibascott]

Is it possible to preserve the selected item in a list box after a form submission. When the form is submitted the page refreshes and the list box selection is reset. How can I keep the same option selected after refresh?

 

[Creto]

Presuming you're building your list from a DB and that that field is being submitted in the form... if the page is submitting to itself, then you can check the request.form("formvarname"), or if it's submitting to another page and then redirecting, set the selected item as a querystring variable and request.querystring("formvarname").

Then, when you get to the select box, you'd set it up like this...

<select>
<%strSelectedOption = Request.Form("yourvarname")
While not rsBoxList.EOF%>
 <option <%if rsBoxList("option") = strSelectedOption Then response.write "selected"%>>
 <%rsBoxList.movenext
Wend

That should set you up.

 

[Creto]

oops, forgot to close the select box... should be...

<select>
<%strSelectedOption = Request.Form("yourvarname")
While not rsBoxList.EOF%>
 <option <%if rsBoxList("option") = strSelectedOption Then response.write "selected"%>>
 <%rsBoxList.movenext
Wend%>
</select>