to populate a recordset in a combo box:
in ASP page
<%
rs.open SQL,connection 'assuming both are there
%>
<select name="combo">
<%
do until rs.eof
%>
<option value="<%=rs(0)%>"><%=rs(0)%></option>
<%
rs.movenext
loop
%>
</select>
Known is handfull, Unknown is worldfull