Program a button that will duplicate a record

Is there a way to program the button so that it can create duplicate record in a new table when it is pressed? If so, what would be the formula to make that happen?
Thank you.