I have a drop down menu that populates infromation from a database. Secondly the confirmation ask user to verify if the conten is correct.
If not correct hit the "Change Data" button which will send them back to make correction. Now the problem I am having is of the following. The drop down menu isn't defaulting to the item or data that was chosen by the user. I am not sure if the problem is in the drop down menu or the confirmation page that has to send them back to make the correction.

Can someone help me with this problem.

Thank you

when you send them back are you using a link which will refresh the page or are you using JavaScript:history.go(-1)

on the submission form the drop down looks like this;

<%
Dim DcType, rsType, mySelection

set dcType=Server.CreateObject("ADODB.CONNECTION")

dcType.Open "Provider=sqloledb;Data Source=Flaflmirsql01;Initial Catalog=Retention;User Id=Retention;Password=nasa#6210;"

Set rsType = Server.CreateObject("ADODB.Recordset")

rsType.open "Type", dcType


 StrType = ""

Do While Not rsType.EOF


StrType = StrType &_
"<Option ='" & rsType("TypeID") & "'"
If (mySelection=rsType("TypeID").Value) Then
     StrType = StrType & " Selected "
End If
StrType = StrType & ">" & rsType("TypeName")&"</Option>"

rsType.MoveNext

Loop

'Clean up
rsType.Close

dcType.Close

Set rsType = Nothing

Set dcType = Nothing

%>

<SELECT name="Type"><%=strType%>

    <option value="Please Choose a Type" >Please Choose a Type</option>

   </SELECT>

Then Submit:

I am sending a JavaScript:

Which looks like this:
<%
Dim StrType
strType= Request.form("Type")

%>
<p align="center">Please confirm the data you entered is correct.<script language="JavaScript">
function ChangeData()
{
    document.form1.action = "Retention_Tool.asp";
    document.form1.submit();
}

function SubmitData()
{
    document.form1.action = "Confirmation2.asp";
    document.form1.submit();
}
</script><form name="form1" method="post">
<table width="100%" border="0">
  <tr>
    <td colspan="2">
    &nbsp;</td>
  </tr>
  <tr>
    <td width="42%">Type of Disco / Downgrade:
<b>:</b></td>
    <td width="57%"><%=strType%><input type="hidden" name="Account_Number" value="<%=strType%>"></td>
  </tr>

did you try storing the query in a session?

Hey,

Yeah, try storing it in the Session to retain it across posts.

Brian