>hi,
>i'm usha from malaysia. I have a problem how to make validation.I've tried to use the coding but it'is does not work.The coding like this
>
>vlocation = location_code
>IF vlocation != land.location_code
>
> DO FORM ("c:\mine\land.scx")
>ELSE
> DO FORM ("c:\mine\error_code.scx")
>ENDIF
>RELEASE thisform
>
>but it'is still have a problem, when I insert the same location code, the error_code form not display.Any Help?Thanks

Here's a guess.......
Is LAND the currently active work area????

If the table in the current work area has a field with the same name as a variable, Fox will recognize the FIELD name rather than the variable.

Try

vlocation = m.location_code


.........Rich