Copy current record to new record

[jibb]

Hello,

I need a button on my form to copy the current record to a new record on the form - how can I do this?

 

[vbaInet]

What's the purpose of this exercise?

 

[jibb]

I have a form showing stock codes and details - we have a lot of codes which are stored as the customers reference but are the same as a standard code. When a new customer code needs setting up I want to view the product details and copy them all to a new record then change the code to the customer code.

Any ideas?

 

[vbaInet]

I'm not completely clear but it sounds like there's a lot of duplication going on there. Can you show us a blown-up screenshot of the Relationships between the Stock and Customers table?