Small problem!

[smael via AccessMonster.com]

hello!
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.

Many thanks in advance!

 

[Guest]

Create an append query that gets the fields from the original record and
appends it to the second table, then create a macro that runs this query and
call it from the onclick event in your form's button, I recommend you have a
primary key on the original record for easier reference when appending the
information to the other table,