# ASP : Populate drop down list

**URL:** <https://forum.kirupa.com/t/asp-populate-drop-down-list/212220>\
**Category:** programming\
**Created:** [January 9, 2007, 1:30pm UTC](https://forum.kirupa.com/t/asp-populate-drop-down-list/212220 "2007-01-09T13:30:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![burns](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@burns](https://forum.kirupa.com/u/burns)\
**Post date:** [January 9, 2007, 1:30pm UTC](https://forum.kirupa.com/t/asp-populate-drop-down-list/212220/1 "2007-01-09T13:30:15Z")

</div>

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?

```auto
 
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