View Single Post
 
Old March 25th, 2004, 09:20 AM
lryckman lryckman is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Connersville, Indiana, USA.
Posts: 126
Thanks: 5
Thanked 0 Times in 0 Posts
Default Code to copy a record from one table to another.

Good morning everyone!
I have created a button that I want to use to copy a record from one table and paste it in another. The table that it will come from is a linked table from another database. I created a query off of that table containing only the fields that I want to be copied over plus one other field (RFQNumber)that will be used to determine which record is copied by the criteria setting. Now I need to write the code that will select all the fields except the RFQNumber field and copy and paste the value of the fields into another table. The field names in both tables are identical.
Any ideas
Please be explanatory as possible. Thank you in advance for any help you can give me.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!