How to copy a record and save as a new record.

[QMDirk]

Hello, can anyone tell me how to copy a record and save it with a different name? The primary index field in the table is Text-formatted but contains the sku numbers of a list of products. The table holding the records contains a lot of fields, 82 ti be exact, and one sku can vary from another sku by as little as one field. That's why I need to be able to copy one record, save it as a different [FPNumber], then alter the couple of fields that are different, rather than re-type all 82 fields.
the table name is "tblNewMI" and the primary key of the table (the first field) is "FPNumber".

 

[theDBguy]

Hi. You could try using an APPEND query.

 

[Pat Hartman]

Your copy button, needs to prompt for the new name. pass that into the append query.