Assume it Connects to the DB and here is part if the Body:
VB Code:
  1. While Not rs.EOF          ' rs is the recordset
  2.     Response.Write("<tr>")
  3.     Response.Write("<td align='left'><i>" & rs.Fields(0).Value & "</i></td>")
  4.     Response.Write("<td align='left'>" & rs.Fields(1).Value & "</td>")
  5.     Response.Write("</tr>")
  6.     CountryValueList &= "<option value = " & rs.Fields(1).Value & ">" & rs.Fields(0).Value & "</option>"
  7.     rs.MoveNext
  8.     End While
  9.     response.write("</table>")
  10.     Response.Write("<br><h4 align = 'center'><SELECT name='CarValue' id='ZarValue'>" & CountryValueList & "</SELECT>")
  11.     DatabaseConnection.close
  12. 'If (Request.Form("btnCalculateRate") = "Calculate Rate") Then
  13.     'button was pressed
  14.     'Else
  15.     'Session.Abandon
  16. 'End If
  17.     Response.Write("<br><h4 align = 'center'>" & CarValue.selectedindex.value & ")
  18. Response.Write("<br><input type='submit' name='btnCalculateRate' value='Calculate Rate'/>

CarValue is the name assigned to the Combobox.
CountryValueList is the name of the countries and the value for each Country is an ID for Example:
South Africa is the Item displayed, its hidden value is 0.88 for example
The problem is the line:
Response.Write("<br><h4 align = 'center'>" & CarValue.selectedindex.value & ") gives the error saying CarValue is undeclared. I also would Like the Code where if I click Sumit it would take the Current Selected Country in the ComboBox, then Display it in a Label. That is what I Am trying to do in the If Statements:
VB Code:
  1. 'If (Request.Form("btnCalculateRate") = "Calculate Rate") Then
  2.     'button was pressed
  3.     'Else
  4.     'Session.Abandon
  5. 'End If


Thanks