I have a form where I want to check if a value is already in the tabke. Because of what I am doing I check as get to next field (also want to check in save button). I use INDEXSEEK(value), SEEK(value), or LOCATE FOR field = value it always seens to return .T. (found the value) even when it is not in the table. If I do the same thing from the command window it works as expected.

What am I missing?

TIA