>>another question, I use a datagrid on the form, and a set of text box.
>>when the user select a record on datagrid, the textboxes show the record too. I allow the user edit the record on the textboxes only, not on the datagrid.
>>How I code? so that when user typing on the textboxes, the datagrid reflect the changed immediately.
>>Eg. -User type "abc", datagrid display "abc"
>> -User press one more key so that "abcd", datagrid display "abcd" at once.
>One way is to update your recordset on every keypress (maybe in the Change event) but it is very time consuming and what about if the users want to cancel his operation?

Can I use the adLockBatchOptimistic? if the user do want cancel something in the datagrid.
thanks for help, my friend