hi,
thank you ,
1.after works , i open the table and change flag to 1 to make test,
i got error message
crstemp is not an object .unbinding object text1, same for text2 and text3

2.i use it at myform--->event---activate

3.and i need to use it at command button after save to get another record.

thanks
>>is ther away to correct this bad code
>>

>>SELECT msisdn,num,date FROM main1 into ;
>>thisform.text3.Value;
>>thisform.text1.Value;
>>thisform.text2.Value;
>>WHERE flag=0
>>

>
>Mohammed:
>
>You cannot bind to controls that way. You create a cursor with tyour query and then bind your controls to the cursor's fields (as one example).
>
>

>SELECT msisdn,num,date FROM main1 into crsTemp WHERE flag=0
>

>Then you bind thisform.text3.ControlSource to crsTemp.msisdn, etc.