>>select temp >>go top >>messagebox(transform(inc_per)) && thiss dispaly the value =4.5 >>thisform.container200.text20.value=inc_per && this dispalys the value =4.5 >>thisform.container200.combo5.value=inc_per && but the value of variable inc_per is not showing in combo >>>>
cnature=alltrim(thisform.container200.combo2.Value) if thisform.container200.combo1.value=ALLTRIM("Filer") text TO cmd TEXTMERGE noshow select afiler,detail from rates where nature='<<cnature>>' ENDTEXT if sqlexec(con, cmd,'nat1') < 0 aerror(laerror) messagebox(laerror[1,2]) return endif select nat1 thisform.container200.combo5.rowsource="nat1.afiler" thisform.container200.combo5.rowsourcetype= 6 thisform.container200.label14.Caption=ALLTRIM(detail) endif