You can put this code in LostFocus event of SearchItem column.textbox
You can also use InteractiveChange of the textbox to see your changes reflected immediatelly...
>Thanks ed for replying
>
>but in which event/method of grid would i specify that.
>
>>>hello
>>>
>>>i have a grid with three fields searchitem,beginitem,enditem.i want to find the begin and end items from another table and put in beginitem and enditem field.
>>>
>>>for example
>>>if user enter 10100 in searchitem it should display 10000,14000 in the beginitem and enditem.
>>>
>>>it get the data from header table where the structure is beginitem and enditem
>>>
>>>10000-14000
>>>14001-15000
>>>....
>>>
>>>txs for any input.
>>
>>Create an index on beginitem and on enditem, and use LOCATE:
>>
>>LOCATE FOR searchitem>= beginitem and searchitem <= enditem
If it's not broken, fix it until it is.
My Blog