Duplicating records

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

Guest

In Access 2003, while entering info on a form, I want to duplicate all the
info then change one field (like maybe a serial number). What is the easiest
way to duplicate a record? Thanks for any help I can get.
 
See:
Assign default values from the last record
at:
http://allenbrowne.com/ser-24.html

Copy the CarryOver() function from the article, and use it in your form. You
can specify the exceptions (i.e. the fields it should not copy), and it's
smart enough to avoid trying to copy the autonumber, unbound controls, or
controls bound to expressions.
 
Back
Top