hello sir,
 I have combo box with an selected options like USA,Australia etd
 When I select say USA. Then I try to save this on SQL database. I hit save. When I hit save on loading the the selected USA option is cleared from the combo box. I donot understand why the code I wrote is as follow. Actually there are several combo boxes with different options. Some the code I have writteen is fro controls

  if Request.Form("txtMode")= "C" then
     if Request.Form("txtID")="" then
     objRST.AddNew()
     end if
      strFName=Request.Form("txtFName")//not a combo box works fine
      strLName=Request.Form("txtLName")// not a combo box works fine
      strBirthDate=Request.Form("txtBDate") // not a combo box works f
      strHireDate=Request.Form("txtHDate")//not a combo box works fine

      strAddress = Request.Form("txtAddress")not a combo box works fine

      strMgrName = Request.Form("ReportsTo")
      strCity = Request.Form("txtCity")
      strPostal=Request.Form("txtPostal")
      strTitle=Request.Form("OPinionasp")//combo box doesnot work
      strRegion= Request.Form("txtRegion")//combo box doesnot work
      strCountry=Request.Form("txtCountry")// combo box doesnot work
      strTitleOfCourtesy=Request.Form("ASPOpinion")//combobox doesnot work
      strReportsTo = Request.Form("Manager")// combo box doesnot work

      objRST.Fields("FirstName")=strFName
      objRST.Fields("LastName")=strLName
      objRST.Fields("BirthDate")=strBirthDate
      objRST.Fields("HireDate")=strHireDate
      objRST.Fields("Address") = strAddress

      objRST.Fields("City")=strCity
      objRST.Fields("PostalCode")=strPostal
      objRST.Fields("Title")=strTitle
      objRST.Fields("TitleOfCourtesy")=strTitleOfCourtes y
      objRST.Fields("Region")=strRegion
      objRST.Fields("Country")=strCountry
      objRST.Fields("ReportsTo")=strReportsTo
      objRST.Update()
      end if

Hello Shoakt,

  May be you didnt give value for the option tags in the select control

<select name="txtCountry">
   <option value="USA">USA</option>
   <option value="Australia">Australia</option>
</select>

When you submit the form the value property is submitted to the page.

May be this is the problem.

Can you post the part of code that was written to display combo box?

_________________________
- Vijay G
Strive for Perfection