Copy record to new record

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

Guest

Using Acess 2003. I have a database to create tranmittals. Very often we
send the same things, or similar to the same person. I want to create a new
record based on an exsiting record number (using an entry "form") and then be
able to edit the new record. Any help would be appreciated.
 
If the data really does not change often (but still must be edit-able) then
you can enter text as a default value for each text box of the Form....and
this will work fine.

However if the data does change with some regularity...maybe every couple
days or so - - then this static fixed method will be a pain in the neck -
particularly if your form has alot of text boxes....

I can't think of an easy & elegant way to "roll" the prior records value to
the next record that can be changed on the fly....you can of course go to the
Table and simply copy/paste the record to new record and then alter....

others may be more helpful than this.....
 
Hi Dave - create a Command Button and attach the Duplicate Record command to
it. With one click you have your new record!
HTH -- yours Dika
 
Back
Top