thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray+1,5),4))>hi,
>thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray+1,5),4))+1 >>thanks
>>SELECT 1 >>SELECT MAX(billno) from mstr INTO ARRAY laAarray >>IF _TALLY > 0 >>thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray+1,5),4))+1 >>ELSE >> >>* Here array laAarray does not exist!! But you want to start from 1? >> >>THISFORM.TEXT1.VALUE = (RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+1,5),4)) >>ENDIF >>