Duplicate previous row's data in next record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top