Hi John,

I created a table called payment with an ins_co_name and added acouple records. Threw a text box and a button on a form. I put the following in the click event of the button:

local cCoName
cCoName = THISFORM.textbox1.VALUE

SELECT * FROM PAYMENT ;
	WHERE ins_co_name = cCoName  ;
	INTO CURSOR Mycursor

IF _TALLY != 0
	WAIT WIND 'got some records'
ELSE
	WAIT WIND 'nothing there'
ENDIF

Note: What is entered in the text box has to match what's in the field as far as case.

>Roi,
>
>Could you give me the me another example just useing a single table ?
>> the table is payment.ins_co_name <
>> the form is search1 <
>> I want the user to be able to enter data in the form.textbox1 <
>> and have it relate to the table payment.ins_co_name <
>> and output to a report <
>> if data found .t. <
>> wait 'Data found will now print ' <
>> report form to preview <
>> Else <
>> Wait 'No data found '
>> Return <
>
>> Please one more time <
>> John <