Duplicate a Form's Entries

From: Sondra <Sondra@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 28 Apr 2005 11:36:01 -0700

Don't know if this is possible or not, but hope someone can help.

I use Access 2002.

My form contains the following fields:
DocumentID
DocumentVersion
Binder1
Binder2
Binder3
Binder4

What I need to know is there a way to have a new record created by
duplicating a previous records entry.

For Example:
Record #1
DocumentID = 10.0.4
DocVer = 1.0
Binder1 = yes
Binder2 = no
Binder3 = yes
Binder4 = yes

Create Record #8
enter DocumentID as 10.0.4

Form Pre-fills with the following information:
DocVer = 1.0
Binder1 = yes
Binder2 = no
Binder3 = yes
Binder4 = yes

Changes:
DocVer = 1.1
Binder2 = yes
Binder3 = no

EndResult =

Record #1
DocumentID = 10.0.4
DocVer = 1.0
Binder1 = yes
Binder2 = no
Binder3 = yes
Binder4 = yes

Record #8 is now
DocumentID = 10.0.4
DocVer = 1.1
Binder1 = yes
Binder2 = yes
Binder3 = no
Binder4 = yes

Any guidance would be FANTASTIC!!!

Thanks.

.

Follow-Ups:
- RE: Duplicate a Form's Entries
  - From: Sprinks

Prev by Date: repost, hasn't been answered :) :)
Next by Date: value to textbox
Previous by thread: repost, hasn't been answered :) :)
Next by thread: RE: Duplicate a Form's Entries
Index(es):
- Date
- Thread

Relevant Pages

RE: Duplicate a Forms Entries
... > DocumentID = 10.0.4 ... > DocVer = 1.0 ... > Binder2 = no ... > Form Pre-fills with the following information: ...
(microsoft.public.access.forms)
RE: Creating a Duplicate Record from previously entered info. on a for
... > DocumentID = 10.0.4 ... > DocVer = 1.0 ... > Binder2 = no ... Hi Sondra, ...
(microsoft.public.access.formscoding)
Re: Creating a Duplicate Record from previously entered info. on a for
... Sondra wrote: ... >DocumentID ... Prev by Date: ...
(microsoft.public.access.formscoding)
Creating a Duplicate Record from previously entered info. on a for
... Binder2 = no ... enter DocumentID as 10.0.4 ... Any guidance would be FANTASTIC!!! ... Prev by Date: ...
(microsoft.public.access.formscoding)