Create a duplicate record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 25 Dec 2004 17:53 GMT

I have a data input form and need to automatically duplicate the existing
record as a new record by clicking a button. The main purpose to duplicate
the record is that the new record is very similar to the existing record
with minor differences. It will save the data input operator a lot of
afford by editing the minor difference only. However, the new record is not
allowed to be saved if the operator forgets to make the modification for
whatever reasons to avoid duplicate records. Your guidance to accomplish it
is appreciated.

Thanks,

Ray

Reply to this Message

Wayne Morgan - 25 Dec 2004 22:08 GMT

Set the Default Value of all of the controls to the controls' current value
then move to a new record. This will set all of the new values to the
current values, but if no changes are made, the new record will be
discarded.

Signature

Wayne Morgan
MS Access MVP

>I have a data input form and need to automatically duplicate the existing
>record as a new record by clicking a button. The main purpose to duplicate
[quoted text clipped - 4 lines]
>for whatever reasons to avoid duplicate records. Your guidance to
>accomplish it is appreciated.

Reply to this Message

Ted - 31 Mar 2005 22:11 GMT

hi,

say i have a form called "Lesions: Target - Baseline" which has a control
(it's a combobox) called "Patient Number".

when the user attempts to add a new record to this form (both "Patient
Number" and "Lesion Number" are on the PK) it'd be nifty if the preceding
"Patient Number" could sort of show up as a default.

but how'd you do that?

> Set the Default Value of all of the controls to the controls' current value
> then move to a new record. This will set all of the new values to the
[quoted text clipped - 9 lines]
> >for whatever reasons to avoid duplicate records. Your guidance to
> >accomplish it is appreciated.

Reply to this Message