Thanks Cetin
The problem I have is that when I put that routine in it copies the record but inputs the value of Key 3 for the new record into moc042 and not the key3 value from the old record. I can only assume that it is carrying out the copy first when I click on the button on the toolbar and then running the routine. Is there anyway I can include some code in another event that stores this value to a variable and then call it later or determine the current record number .
MAny Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd