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
Sarah King
pcpropertymanager.com