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
 
Back
Top