Hi Richard,
I have a Composite Key which incorporates 7 fields so that the application cannot create a duplicate record.  None of these fields are Indexed! If I delete the Required attribute Required = Yes your copy routine creates a new record but all the fields are blank.  If I delete the Composite key it creates the copy record as it should.  Obviously I need to create a copied record with a change in one of those 7 fields to ensure it is unique for the composite key which my code does but it still doesn't work.  Is there a way so I can use your awesome copy routine and keep the composite key?

At this point I have deleted the composite key as it is unlikely that a duplicate record can be created but it is possible if the user isn't careful.
Regards  Ron