Hi Nadya
Thanks for coding. I have tried your coding, It seem work for duplicate the record and increase the item no by 1. But the new record that i duplicated, it inserted at the below of the record, is not insert into the second line or third line, in the between the record. I have two type of split. The Record which i display into Grid, the split is = 'M', All duplicate record I created, the Split = 'C'.

for example , I have 4 record split is 'M'.
cSplit Item no Product
M 1 A
M 2 B
M 3 C
M 4 D

I click on the Button Split M, the duplicate record will display on the second line, and Split = 'C' and item no is 2, the following record, item no will become 3, 4,5...

cSplit Item no Product
M 1 A
C 2 A --- Duplicate
M 3 B
M 4 C
M 5 D

Notes: cSplit 'C' will not duplicate record, only cSplit 'M' will do

If click on the first cSplit 'M' again, the duplicate record will inserted at line 3 and item no will + 1

cSplit Item no Product
M 1 A
C 2 A --- Duplicate
C 3 A --- Duplicate
M 4 B
M 5 C
M 6 D

If click on the second Split 'M' again, the duplicate record will inserted at line 5 and item no will + 1

cSplit Item no Product
M 1 A
C 2 A --- Duplicate
C 3 A --- Duplicate
M 4 B
C 5 B --- Duplicate
M 6 C
M 7 D

Can you please help on this? Thanks