Copy form data from one record to another

[digger27]

I have a question about duplicating form data that is similar to many of the
"Duplicate Records" questions in the news group, but mine is just a bit
different.

I have a form that has a LOT of fields (230) spread across several tabs on
the form. The form pulls from a query that pulls data from several tables.

What I want to do is copy all of the data in all of the fields on the form
and paste them when I go to another record on the form. Let me explain the
work flow so that this is clearer. We are a plumbing company and we keep
track of the jobs we are working, including faucet, pipe, tub info, etc. The
primary key that links all of the tables is our job code. When we get a new
job one of our staff enters the basic info into the main table, including the
job number. Later, when all of the extra data is provided, another staff
member opens this large form and enters the rest of the info. This is where
my problem is different from others that I have seen since I don't need to
create an entirely new record, I just need to fill in the fields in an
existing record.

Any ideas?

 

[Mike Painter]

I have a question about duplicating form data that is similar to many
of the "Duplicate Records" questions in the news group, but mine is
just a bit different.

I have a form that has a LOT of fields (230) spread across several
tabs on the form. The form pulls from a query that pulls data from
several tables.

What I want to do is copy all of the data in all of the fields on the
form and paste them when I go to another record on the form. Let me
explain the work flow so that this is clearer. We are a plumbing
company and we keep track of the jobs we are working, including
faucet, pipe, tub info, etc. The primary key that links all of the
tables is our job code. When we get a new job one of our staff
enters the basic info into the main table, including the job number.
Later, when all of the extra data is provided, another staff member
opens this large form and enters the rest of the info. This is where
my problem is different from others that I have seen since I don't
need to create an entirely new record, I just need to fill in the
fields in an existing record.

From what you have said, there is no need for 230 fields on a record and no
need to update a single record with information from other sources.

The extra data you speak of probably falls into a few different categories
and should all be in related tables.

A jobs table would contain the job number, customer ID,a start and stop date
and anything else that is unique to that job. Maybe something to indicate if
this is your job or you are a subcontractor.
Pieces and parts for the job go in a table with a part number, the job ID,
and maybe quantity or price info.

If you insist on placeing all the data into a flat file format Excel would
be almost as good.