Getting hidden value from field

ok, if u want to get the value in the next page, just simply use
var = request("ALTPOC_ID")
then the value of ALTPOC_ID will be stored in var.

u can use request or request.string, both will be worked

hope this help

Hi, by the look of your code:

ALTPOC_ID = request.querystring("User_ID")

User_ID is passed in the URL, i.e. 'mypage.asp?User_ID=123'

is that what you want? and what exactly do you want to do with it?

Maybe:

<%

ALTPOC_ID = request.querystring("User_ID")
Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs = Server.CreateObject("ADODB.Recordset")

oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/data/database.mdb")

strSQL = "SELECT User_ID,FullName,Agency,Phone,Email FROM Users "


WHILE NOT oRs.EOF

      IF oRs("FullName") = "Select Sponsor" THEN
            strFullName = strFullName & "<option selected value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
      ELSE
            strFullName = strFullName & "<option value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
      END IF
      oRs.MoveNext

      response.write "<input type=""hidden"" name=""ALTPOC_ID"" value=" & oRs("User_ID") & ">"

WEND

oRs.Close
oConn.Close

%>

butter_fly,
Try this in your code...This may work..
<input type="hidden" name="userID" value="&lt;%= ALTPOC_ID %&gt;">

Since each User_ID belongs to a different record..you want to repeat it within the loop:


 <%
             ALTPOC_ID = request.querystring("User_ID")
            Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs = Server.CreateObject("ADODB.Recordset")
oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/data/database.mdb")
           
     strSQL = "SELECT User_ID,FullName,Agency,Phone,Email FROM Users "


WHILE NOT oRs.EOF

IF oRs("FullName") = "Select Sponsor" THEN
    strFullName = strFullName & "<option selected value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
ELSE strFullName = strFullName & "<option value=" & oRs("User_ID") & ">" & oRs("FullName") & "</option>"
END IF
oRs.MoveNext

WEND

  oRs.Close
oConn.Close

'beginning of your form goes here
response.write ("<select name='User_ID' size='1'>" & strFullName & "</select>")
' rest of your form goes here
%>

Now when a user submits from this page...selects the user_id...have another page which inserts the record. Oh and make sure your form is set to "get" not "post"

Hello,

The FullName Combo Box is populating fine now. However, the corresponding text field named ALTPOC_ID is not changing value along with the combo box...I guess I need another if statement to make that part work..i hope i make sense. im confused is all..
so if i pick John Smith then the ALTPOC field should read 21 or whatever record that is...right now it's just saying unknown..

<%
              Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs = Server.CreateObject("ADODB.Recordset")
oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/data/database.mdb")
             
      strSQL = "SELECT User_ID,FullName,Agency,Phone,Email,ALTPOC_ID FROM Users "
      'strSQL = strSQL & "WHERE User_ID = Users.User_ID"

oRs.Open strSQL, oConn, adOpenKeyset, adLockOptimistic

WHILE NOT oRs.EOF

IF oRs("FullName") = "Select Sponsor" THEN
    strFullName = strFullName & "<option selected value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
       ALTPOC_ID = "Unknown"
ELSE strFullName = strFullName & "<option value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
 'ALTPOC_ID = oRs("User_ID")
 ALTPOC_ID = "Unknown"
END IF
oRs.MoveNext

WEND

  oRs.Close
oConn.Close
%>


'form here..

   <select size="1" name="FullName">
                          <%=strFullName%>
                          <option value="Unknown" selected>Select Sponsor</option>
                        </select></font>
                        <input type="" name="ALTPOC_ID" value="<% =ALTPOC_ID %>"> THIS DOESNT WORK...=(

You could do that using JavaScript. But if all you really want is that when someone SUBMITS this form for ALTPOC_ID to appear in the URL or something, all you have to do is:


WHILE NOT oRs.EOF

IF oRs("FullName") = "Select Sponsor" THEN
    strFullName = strFullName & "<option selected value=" & oRs("FullName") & ">" & oRs("FullName") & "</option>"
ELSE
  strFullName = strFullName & "<option value=" & oRs("UserID") & ">" & oRs("FullName") & "</option>"
END IF
oRs.MoveNext

... that way when you submit the form doing Request.Form("FullName") will have the user id....

Hi,

I removed the request.querystring portion of the code because it wasn't what I was trying to do. I have a drop down box (FullName) which is populating fine. The corresponding text box named ALTPOC is not populating though. I think I'm missing another if statement to make that field work..

In a nutshell, I have the FullName combo box populating, I need it's corresponding text field box to populate based on the combo box selection.

COMBO BOX -populates, user picks John Smith   TEXT FIELD ALTPOC - should display User_ID based on user's select from combo Box so if John Smith is picked then this box should read '21'

Right now, it's reading nothing =( ick...so im guessing im missing another select for this TEXT FIELD