ASP : Populate drop down list

programming
1

Hi,

I’m having trouble populating a form dropdown box from a access DB RS. Does anyone know of a way to do this and that allows you to change the value of the dropdown and
re-submit?

 
Response.write("<option value='Corporate'>Corporate</option>")
Response.write ("<option value='Customer Services'>Customer Services</option>")
Response.write ("<option value='Authoring Creative'>Authoring &amp; Creative</option>")
 Response.write ("<option value='Production'>Production</option>")
 Response.write ("<option value='Finance'>Finance</option>")
 Response.write ("<option value='Artwork'>Artwork</option>")
 Response.write ("<option value='It'>IT </option>")
Response.write ("<option value='Warehouse'>Warehouse</option>")
Response.write ("<option value='Sales'>Sales</option>")
Response.write ("<option value='Purchasing'>Purchasing</option>")
Response.Write("<option selected=""selected"" value=""" & recordset("strDepartment") & """>" & _
                      recordset("strDepartment") & "</option>")

ok, so the above code select the relevent department from the db but it duplicates.

Thanks