populating drop down menu with values from access DB

[ifeyinwa]

I would like to populate my drop down menu on an asp page with values from a database-ACCESS.
below is what i have so far , it gives me no errors but the drop down is not being populated.pls what am i not doing right???. New too this functionality

<select size="2" name="AUserName">
<OPTION value=0>--choose an employee
<%
Set RS = conn.Execute("SELECT Access_UserName FROM flt_adm")
Response.write SQLstmt

Do Until RS.EOF
%>
<OPTION Value="<%=RS("Access_UserName")%>"></option>
<%
RS.MoveNext
Loop
RS.Close
%>
</SELECT>

thanks as always ify

 

[ifeyinwa]

thanks Ifigured out my error used this
<OPTION Value="<%=RS("Access_UserName")%>"></option
instead of
<OPTION Value="<%=response.write rs("Access_UserName")%>"></option
thanks!!