>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
vlocation=location_code if indexseek(vlocation, .f., 'land','location_code') * This code is already in table Land, display your Error form else * Ok, this is a new code, let's continue... endifNote, IndexSeek is a new VFP 6.0 function. Which version of VFP do you use?