Use Insert Like to add a new record to the table and copy the data from the selected record to the new record. By default, the data from all columns is copied. However, the data from a column may be prevented from being copied by deselecting the Copyable check box for the column of the record. The Copyable check box is in the User Control Properties dialog box > Data Window tab > Columns pane.
The inserted record is highlighted in green to denote that the record is not yet saved.