I usually set the combo
.rowsource=select * from rank into cursor temp
.rowsourcetype=3 (SQL Statement I think it's three.)

Then in the destroy I do..
IF USED("temp")
use in temp
ENDIF

In the refresh
this.displayvalue=mytable.value

in the lost focus or valid
replace value with this.displayvalue in mytable


HTH