I&#039;ve built the web site, using your assistance to get the db connection correct, so now I need to make a major change.<BR><BR>The site currently uses the monthly premium to calculate the Life Cover, I need to swap this round.<BR><BR>There is the code:-<BR><BR>&#060;%<BR> Response.Buffer = True<BR> Dim intAge, bNonSmoker, txtGender, curPremium<BR> if IsEmpty(Request.Form("select_age")) then<BR> intAge = 20<BR> else<BR> intAge = Request.Form("select_age")<BR> end if<BR> if IsEmpty(Request.Form("NonSmoker")) then<BR> bNonSmoker = true<BR> else<BR> bNonSmoker = (Request.Form("NonSmoker") = "Yes")<BR> end if<BR> if IsEmpty(Request.Form("Gender")) then<BR> txtGender = "Male"<BR> else<BR> txtGender = Request.Form("Gender")<BR> end if<BR>******************************************** ********************<BR> dim MinPremium, MaxPremium<BR> MinPremium = 10 <BR> MaxPremium = 100<BR> commission = 25 <BR> if IsEmpty(Request.Form("select_premium")) then<BR> curPremium = MinPremium<BR> else<BR> curPremium = CCur(Request.Form("select_premium"))<BR>********** ************************************************** ****<BR> end if<BR> dim adoConn, rsCost<BR> set adoConn = CreateObject("ADODB.Connection")<BR> set rsAges = CreateObject("ADODB.Recordset")<BR> set rsCost = CreateObject("ADODB.Recordset")<BR><BR> filePath = Server.MapPath("Database/costs15.mdb")<BR> strConn = "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & filePath<BR> adoConn.Open strConn<BR> <BR> intEffectiveAge = intAge<BR> if txtGender = "Female" then<BR> intEffectiveAge = intEffectiveAge - 5 &#039; 5 years difference for women<BR> if intEffectiveAge &#060; 20 then intEffectiveAge = 20<BR> end if<BR> if bNonSmoker then<BR> txtCostField = "[Non Smoker Cost]"<BR> else<BR> txtCostField = "[Smoker Cost]"<BR> end if<BR> strSQL = "SELECT " & txtCostField & " as Cost FROM Costs WHERE ([AGE NEXT] = " & intEffectiveAge & ")"<BR> rsCost.Open strSQL, adoConn<BR> adjustmentFactor = (100 - commission)/100.0<BR> if not rsCost.BOF then<BR><BR> rate = rsCost("Cost")<BR> lifeAss = curPremium * adjustmentFactor/rate * 1000<BR> lifeAss = int(100*lifeAss)/100<BR> else<BR> Response.Write "Could not find cost for age " & intAge<BR> end if<BR> rsCost.Close<BR>%&#062;<BR><BR>The calculations are easily changed, but the problems arise when the "fillpremium.inc" is changed to a drop down menu, this replaces the minimum/maximum premium.<BR><BR>When this is done, the site works, but the selected life cover return to the minimum figure, no mater which figure was selected.<BR><BR>Can any one suggest a way round this problem!!!!<BR>