>The reason I wanted to try the LOCATE was cause with the SEEK() does not work correctly. This is what I’m doing:
>
>IIF(SEEK(THISFORM.r_year+result.source,'Temp','Temp'),Temp.descr," ")
>
>It doesn’t find the right info, although, it does exist. I also tried setting EXACT ON and still doesn’t find it.
>
>any ideas?
That's why I included the PADR() on the fyr and source fields, so the length of the expression matches the length of the field.
Make sure the index expression is fyr+source.
If you want to use the form properties, ALLTRIM() them first, e.g.
lcSearch = PADR(ALLTRIM(thisform.r_year),FSIZE("fyr","temp"))+ ;
PADR(ALLTRIM(result.source,FSIZE("source","temp"))
IIF(SEEK(lcSearch, "temp", "temp"),temp.descr," ")
Insanity: Doing the same thing over and over and expecting different results.