dropdown menu

<i><b>Originally posted by : Gio (gciocche@yahoo.com)</b></i><br />I have an ASP page and I am populating a dropdown box with information from a database and I am masking some of the data. I am using the following code for when a user clicks on a submit button, it holds the users selection without refreshing the page.<br /><br /><option selected><%=Request.Form("EmpRecord")%></option><br /><br />The problem is that when it comes back through, it is displaying the unmasked data and not the masked data. <br /><br /><%SQLStr = "usp_Employees '" + Session("CenterNumber") + "'"<br />Set RS = EmpConn.Execute(SQLStr) %> <br /><SELECT id=EmpRecord name=EmpRecord><br /><option selected><%=Request.Form("SubEmpRecord")%></option><br /><%Do While not RS.EOF %><br /><option value='<%=RS("emp_record")%>'><%=RS("emp_record_display")%></option> <br /><%RS.MoveNext%><br /><%loop%><br /></SELECT><br /><% RS.close%><br />