Duplicate previous row's data in next record

[Guest]

Each record starts with an Autonum Id Field which is incremented by one; ten
fields follow. I need a control button on my data entry form to add the row
of data; then start a new record by incrementing the first Autonum Id Field
and duplicating all remaining fields with the same values from the previous
record. Any suggestions?

 

[Guest]

JJF,

One day to do is is to set the DefaultValue property of each field in its
AfterUpdate event:

Me!YourControl.DefaultValue = Me!YourControl

Sprinks