What about

SELECT MAX(BILLNO) FROM mstr INTO ARRAY laArray
IF _TALLY > 0
  THISFORM.TEXT1.VALUE = laArray + 1
ELSE
  THISFORM.TEXT1.VALUE = 1
ENDIF

>hi ,
>
>if i start now to insert my first bill
>i want to get billno=1 at my THISFORM.TEXT1.VALUE ,
>.
>i try to change as
>1.IF _TALLY >= 0
>2.IF _TALLY > 0 or _TALLY =0
>i get error message (laArray is not found),
>
>
>

>this code works exellent but if i have at least one bill at my table
>SELECT MAX(BILLNO) FROM mstr INTO ARRAY laArray
>IF _TALLY > 0
>  THISFORM.TEXT1.VALUE = laArray + 1
>ENDIF
>
>

>
>thanks
>m.qasem