WITH ThisForm lcBillNo = .Text1.Value ldDateIn = .Text2.Value ENDWITH SELECT * FROM mstr INTO CURSOR temp WHERE BILLNO=lcBillNo AND DATEIN=lcDateIn IF _TALLY <= 0 MESSAGEBOX( "No records found!" ) ENDIFHope to help,
>SELECT mstr >>LOCATE FOR BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE >>IF FOUND() >>SET FILTER TO BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE >> > >>