Way back when I was starting out in vfp I found I had problems getting combo boxes to display the correct data so made the gotfocus() method look like this.

this.rowsourceType = 3
this.rowsource = lcSqlQuery + "into cursor cSql"
this.value = table.fieldvalue
this.displayvalue = Lookup( cSql.display, this.value, cSql.Id)

if empty(this.displayvalue)
*// put in the default values
endif

I've tried to make this as readable as possible. Is this a correct approach or have my initial problems led me off in the wrong direction?

Sarah