Duplicating a record

[Dave]

I am using Access 97 and Windows 2000 Pro. There is probably an easy answer
to this question. How do I copy the contents from one record to another
record in the same table? Any help would be appreciated.

Thanks in Advance....
Dave
Professional Document Systems, Inc.

 

[Duane Hookom]

"To another record" do you mean an existing record or a new record? Do you
want to duplicate all fields or just some? Is the record you want to copy
the one currently on a form or any other record? Did you try use a command
button wizard?

 

[Dave]

Duane;

Thanks for the reply. I guess I didn't make myself clear but I want to copy
to an existing record and all fields.

Thanks again
Dave
Professional Document Systems, Inc.

 

[Dave]

Duane

The file number or record number would be different and yes it is very
desirable as our clients would like to save a whole bunch of data entry.
Our software is used by lawyers to create the paper work for Real Estate
closings. Now with refinancing going on it would save our clients a lot of
work if they could copy the data from a previous closing to the new file
when a refinance is going to take place.

as an example:

John Doe buys a house and Steve Smith the lawyer prepares the closing
documents. All goes well and the closing takes place. 6 months down the
road John Doe decides he wants to refinance the loan and comes to Steve
Smith the do the closing. Now Steve Smith needs to retain the records from
the first closing but would like to save time by copying the data from the
original closing to the new closing. That is what I am trying to do. I
have come up with a solution by coding a module to do this but it is quite
big. I was wondering if there was a quick and dirty method.

Thanks
Dave

 

[Duane Hookom]

The easiest method would be an append query that would append all the fields
except the FileNumber from one record to a new record in the same table. If
your application is anything like several I have worked on in the past, each
"blank" on the loan application paper form is a field (un-normalized but
works).

If you must do this where the "target" record is an existing record and they
are both in the same table, I would write a function that opens two
recordsets (one for the "Source" and one for the "Target") and loops through
the fields collection updating the Target record with the Source values.