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