Hey guys,<BR><BR>I am trying to create a loop that would list each column name in the table and create a <select> form that would contain each DISTINCT entry. Listing each column name seems to be fine but every <select> option is blank except for the first one. It should be a simple little script but I am having trouble. Here is my code:<BR><BR><BR>set rs=Server.CreateObject("ADODB.recordset")<BR>sql=" SELECT * FROM employee"<BR>rs.Open sql,conn<BR><BR>for each x in rs.fields<BR>%><%=x.name%><BR>< ;select name="<%=x.name%>"><BR><%<BR>d o until rs.EOF<BR>response.write("<option>")<BR> response.write(rs.fields("location"))<BR>rs.MoveNe xt<BR>loop%><BR></select><BR><%<BR>next<BR>%><BR> any help would be greatly appreciated. thanks!