Duplicate Button that updates autonumber

[joepineapples]

I have a form that has several fields.

What I would like is to use the duplicate button. The problem I have is that this duplicates a field that has an autonumber (which is set to not accept duplicate numbers).

Is there a way to create a duplicate but replace the problem field with a new auto number?

or

Is there a way to create a new record and copy over some of the fields from the 'master' record? This would probably be my preferred solution.

Many Thanks for any help.

JP

 

[Dennisk]

Autonumbers are incremented automatically for you when add a new record.

Test this out by createing a table with an autonumber and text field.

open the table and enter data into the text field, observe what happens to the autonumber.

 

[MStef]

Do it with APPEND query.

 

[joepineapples]

Thanks Dennisk - you are right I was being a complete numpy!

 

[neileg]

As MSte says, an append query is the way to go. You append all or some of the fields to a new record, except the auto number. The new autonumber will be created for you.