Duplicating a record

  • Thread starter Thread starter limpetsfolly
  • Start date Start date
L

limpetsfolly

I have a form containg information to issue a cutomer quotation. I wan
to be able to duplicate selected records to issue a variation on th
original quotation - most of the data will be the same. I've trie
using the "duplicate record" function via a command button but nothin
happens. The underlying table has an autonumber index key field and
wondered whether the function is trying to paste a duplicate key? Ho
can I copy across the majority of a record to a new record bu
generating the next key automatically?
I'm using Access 2000
 
It appears that your primary key is an autonumber filed. If so creat
an append query where all desired fields are based on the presen
record on the form. Then ahave to form got to that record fo
additional editing.

Goof Luc
 
You must log in or register to reply here.

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

Copy or Duplicate Record Woes 3
Duplicate values 4
Duplicate values in the index, primary key, or relationship messag 2
Create duplicate data 1
Autonumber trying to create duplicates 3
Cleaning Duplicate Records 3
Writing SQL code to delete duplicate records 0
Duplicate records - eliminate from totals 11

Back
Top