it is simple you can fetch a value making a record set object. and use this type of code resonse.write("<option>" & rs("Fieldname") & "</option>" remember you have to close the select tag at the end.