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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if duplicate goto record 3
Writing SQL code to delete duplicate records 0
Indexing-No Duplicates Problem 5
Unique entries 3
Duplicate values 4
Duplicate values in the index, primary key, or relationship messag 2
how to avoid duplicate records 2
Copying data between duplicate records 2

Back
Top