OK, Let's continue.

How does the form1 work? You must have something like a textbox and a ControlSource in order to store the value you want to search in table land.
What is your ControlSource ?

Also, you have to 'locate' or 'seek' your record.

How are you doing that?

Juan Carlos.


>Hi,
>I'm sorry because may be you do not understand my problem. For your Information, i'm create a form (form1)for insert location code. So from this form it will go to the next form (add data for land form)=form2.So I want when the user insert the same location code, the error form will be display.
>
>Which values do 'WAIT WINDOW command' show you?
>
>value for location code when I insert the location code in first form before continue to land form(form2).