AskaSQLGURU.com

I have a problem posting an input field to another .asp page.  My code authenticates against an Access DB and that work, I just can't get it post to the next page.  Looking for assistance.  Here's my code:

Authentication Code:

<!--#include file="Connections/conn.asp" -->

<%

' *** Validate request to log in to this site.

MM_LoginAction = Request.ServerVariables("URL")

If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)

MM_valUsername=CStr(Request.Form("ClientID"))

If MM_valUsername <> "" Then

 MM_fldUserAuthorization=""

 MM_redirectLoginSuccess="survey_questions.asp"

 MM_redirectLoginFailed="login_fail.asp"

 MM_flag="ADODB.Recordset"

 set MM_rsUser = Server.CreateObject(MM_flag)

 MM_rsUser.ActiveConnection = MM_conn_STRING

 MM_rsUser.Source = "SELECT ClientID"

 If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization

 MM_rsUser.Source = MM_rsUser.Source & " FROM tblclientinfo WHERE ClientID='" & Replace(MM_valUsername,"'","''") & "'"

 MM_rsUser.CursorType = 0

 MM_rsUser.CursorLocation = 2

 MM_rsUser.LockType = 3

 MM_rsUser.Open

 If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then

   ' username and password match - this is a valid user

   Session("MM_Username") = MM_valUsername

   If (MM_fldUserAuthorization <> "") Then

     Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)

   Else

     Session("MM_UserAuthorization") = ""

   End If

   if CStr(Request.QueryString("accessdenied")) <> "" And false Then

     MM_redirectLoginSuccess = Request.QueryString("accessdenied")

   End If

   MM_rsUser.Close

   Response.Redirect(MM_redirectLoginSuccess)

 End If

 MM_rsUser.Close

 Response.Redirect(MM_redirectLoginFailed)

End If

%>

Form:

<form action="<%=MM_LoginAction%>" name="ClientID" method="post">                Client Account Number:

<input name="ClientID" type="text" size="15" maxlength="15" />

<option>

<% = Request.Form("ClientID") %>

</option>

<input type="submit" name="Submit" value="Submit" />

</form>

Next Page Form:

<form method="POST" name="survey" action="survey_finish.asp">

      <input type="hidden" value="<% = Request.Form("ClientID") %>" name="ClientID">

Where I want to displayed:

<td class="black11b"><% = Request.Form("ClientID") %></td>

Thanks for you help.

I know a little bit about making SQL work for a dynamic website, but I&#39;m no world renowned expert