I am sorry that is not the problem.
- The Locate function onlt finds the first record in MyTable.

If I use Locate to find a record that is not the first record it does not find it. What could be wrong?

Ria

<Does locate work when issued succeessively?

When I issue thr LOCATE statements below in the command window this is what happens.

Select MyTable
Locate for Alltrim(Upper(TABNAME)) == "ATAB" and FORMNAME == "MYFORM"
? FOUND(), returns .t.

Locate for Alltrim(Upper(TABNAME)) == "BTAB" and FORMNAME == "MYFORM"
? FOUND(), returns .f.

BTAB & ATAB are in MYTable

Any thoughts on this?

Thank you.

Ria

>>