Ok, I have a table with a requested_by column that holds the requested client's name. There is an "EDIT" form that allows the user to make changes. In the form there is a dropdown list that displays the selected client first and then a list of the other available clients. I want the dropdown list to include all of the values expect the one that is being edited. Here is some of my code, hopefully this will help:
strSQL = "SELECT * FROM MChange WHERE cid= " & intCid & ";"
Set rstSearch = Server.CreateObject("ADODB.Recordset")
strSQL1 = "SELECT * FROM Client;
Set rstSearch2=Server.CreateObject("ADODB.Recordset")
<option selected="<%= Server.HTMLEncode(rstSearch.Fields("requested_by").Value) %>"><%= Server.HTMLEncode(rstSearch.Fields("requested_by").Value) %>
<option><%=rstsearch3.fields("First_Name").value%><%=" "%><%=rstSearch3.fields("Last_Name").Value %></option>
PM me if you need any clarification, I am kind of stuck on getting this to work.
strSQL = "SELECT * FROM MChange WHERE cid= " & intCid & ";"
Set rstSearch = Server.CreateObject("ADODB.Recordset")
strSQL1 = "SELECT * FROM Client;
Set rstSearch2=Server.CreateObject("ADODB.Recordset")
<option selected="<%= Server.HTMLEncode(rstSearch.Fields("requested_by").Value) %>"><%= Server.HTMLEncode(rstSearch.Fields("requested_by").Value) %>
<option><%=rstsearch3.fields("First_Name").value%><%=" "%><%=rstSearch3.fields("Last_Name").Value %></option>
PM me if you need any clarification, I am kind of stuck on getting this to work.
