Duplicate a record

[smael via AccessMonster.com]

I have a data input form and need to automatically duplicate the existing
record as a new record in a new table (Annonce_OUi) by clicking a button.
The main purpose to duplicate
the record is that the new record is very similar to the existing record.
Many thanks in advance.

Thanks!