You said - "if i choice io2 i see at another grid io2 ,ok
but if i choise io3,i see io2 and io3,
i need to insert just i03 at another grid,whay it take 2 items"

but you also say - "but i want to insert many items,no need for delete operation"

I dont understand what you want to do?

If you have grid1 and select a record it goes into grid2?

Please explain again.




>hi,
>thank you for reply,
>still, the code insert 2 items at my grid ,but the first 1 marked to delete,
>but i want to insert many items,no need for delete operation,
>thank you
>
>>Is this the code that adds the record to Grid2? If so its because the table used as the record source still has the fist record in it you need to clear down the temp table before adding the new record.
>>with thisform.Grid1
>>* before the appen blank delete everything in the temp table
>>SELECT temp
>>DELETE ALL
>>APPEN BLANK
>>REPLACE temp.typ WITH THISFORM.GRID2.column1.text1.VALUE
>>.Recordsource = .Recordsource
>>ENDWITH
>>GO top
>>thisform.grid1.refresh
>>
>>
>>
>>>hi,
>>>thank you for reply,
>>>i try but still same,
>>>the problem as under...
>>>

>>>i see at mygrid as ex. this item have
>>>io2
>>>io3
>>>io4
>>>io5
>>>if i choice io2 i see at another grid io2 ,ok
>>>but if i choise io3,i see io2 and io3,
>>>i need to insert just i03 at another grid,whay it take 2 items
>>>
>>>

>>>this is the code
>>>

>>>set exact on
>>> set near off
>>>select 3
>>>
>>>with thisform.Grid1
>>>APPEN BLANK
>>>REPLACE temp.typ WITH THISFORM.GRID2.column1.text1.VALUE
>>>.Recordsource = .Recordsource
>>>ENDWITH
>>>GO top
>>>thisform.grid1.refresh
>>>
>>>

>>>
>>>thanks
>>>>try
>>>>

>>>> set exact on
>>>> set near off
>>>>

>>>>before your code