Can't select in my dropdown menu

[screaming_banjo]

I'm populating a drop down menu with options from a database, problem is that when I view it in the browser and click on one of the options....none of them get 'selected' when I view the HTML source. I'm a beginner at ASP so hope that I'm making sense here!

Here's the code I've got

<form name="FrmDept" method="post" action="rogmorris.asp">
<select ="DeptID" class="dropdowns" onChange="this.form.submit()">
<option value="0">Select Here</option>
<% DO WHILE NOT rsRogDept.EOF %>
<option value="<%= rsRogDept("mordeptID") %>" <% If rsRogDept("mordeptID") = int(request("DeptID")) Then response.write "SELECTED" %>> <%= rsRogDept("morDept") %></option>
<% rsRogDept.Movenext
LOOP
%>
</select>
</form>

Anyone got any ideas why nothing gets selected?

Thanks in advance for any help.

[stevem2004]

you can use the following code:-


<select name="DeptID">
<option value="youroption1" <% if CStr(rs("DeptID") & "")="youroption1" then Response.Write " selected" end if%>>youroption1</option>
<option value="youroption2" <% if CStr(rs("DeptID") & "")="youroption2" then Response.Write " selected" end if%>>youroption2</option>
</select>

You'll need to replace rs to your record source rsRogDept.

You don't need the DO WHILE NOT or Movenext LOOP in the script.

Hope this helps

[screaming_banjo]

Thanks for your help, I'll give that a go!