I am not sure what you are trying to do here.
objRS.Open "Escalation_Forms", objConn, 0, 1
'Loop through recordset and display results
If Not objRS.EOF Then
how many rows does "Escalation_Forms" return? Are you trying
to loop through the recordset? If so, where is the "While NOT objRs.EOF",
but you just have a "objRS.MoveNext" below.
'the form below calls this file only this time with an id in the QueryString
Your form's METHOD is GET, but you are requesting values using Request.FORM()
on top of this page. I am not sure if this FORM submits to the same page.
If submitted to same page, REQUEST.FORM() is the wrong way of getting values.
<form action="Eta_database4.asp" method="get" style="text-align: center">
Why is this Option tag oustide the SELECT tag?
<option value="<%= objRS.Fields("Escalation_Type") %>"></option>
<select name="Escalation_Type" size="1">
Escalation_Type will hold nothing if any of the following Options chosen,
coz' you haven't given any of those a VALUE listed below.
<option selected>Choose One</option>
<option>HDTV Call Back</option>
<option> Supervisor Call Back</option>
If you are very much bothered about the checkbox values
getting displayed than correcting other errors, then replace this code on top of the page.
'If Len(Request.Form("Escalation_Type")) <> " " Then
'strStatus = request.form("Status")
Escalation_Type will still hold nothing. Status would display something if any value is checked.
- Vijay G
Strive for Perfection