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.
NetworkTrade - 23 Aug 2006 18:16 GMT
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.....

Signature
NTC
> 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.
Kernow Girl - 25 Aug 2006 15:04 GMT
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
> 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.