>Thanks Nick,
>It works great. I have only one problem, when try print my report my report gives me a error messagevariable 'first_name'
>my code is as follows :
>SELECT * from policy ;
>WHERE policy.group_code == lcGroupCode ;
>AND policy.ins_co_name== lcIns_co_name ;
>INTO CURSOR myReport
>
>IF RECCOUNT ("myReport") >0
>select myReport
>* I added next line
>REPOT FORM PAYNENT1 PREVIEW
>ELSE
>?? CHR(7)
>WAIT WINDOW "MATCH NOT FOUND, TRY AGAIN" TIME 2 NOWAIT
>ENDIF
>USE IN myReport
>thisform.text1.value=""
>thisform.text2.value""
>thisform.refresh()
>thisform.text1.setFocus()
>**
>**
>I have no DE in the report form, and all of the fields have no table call (table.field) but it comes up with the error
>message variable 'first_name' is not there.
>
>Don't have any idea what it could be.
>
>NEWBE.
>THANKS JOHN

Did you check Print When condition for your report fields? There may be something there.