Code to duplicate records

[Paolo]

Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.

[Lyle Fairfield]

jp***@tin.it (Paolo) wrote in news:9f41a860.0402110641.11be4d11
@posting.google.com:

Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.

Perhaps, here:

http://www.psychosurgery.org/index_files/Page607.htm

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Mike Storr]

What have you figured out so far, or have you not done any looking through
help files? What you are trying to do is extremely simple, 1 append query, 2
DoCmd Lines.

Mike Storr
www.veraccess.com
"Paolo" <jp***@tin.it> wrote in message
news:9f**************************@posting.google.c om...

Hello,
I am again submitting my question since have not had much luck with my
previous posting.

What I am trying to do is duplicate data from one table to another. I
know is not the correct procedure but would like some help with code.
Basically I have a form named CLAIMS which has it's record source to a
table also named CLAIMS. This table has 5 fields: SSN, FNAME, LNAME,
DATE, INITIALS.

I would like to add a cmdbutton on my form that duplicates (copies)
the data that I have just entered in the form into another table,
named APPLICATIONS.

Please note that the code should copy the records, close the active
form (in this case will be the form named CLAIMS), paste the data into
the table named APPLICATIONS and finally open the form APPLICATIONS to
show the data that has just been duplicated.

Can anyone help me? Thanks.