Copy Data From One Table To Another

[JTK1980]

I am new to Access, I have searched through the forums for an answer and have had no luck yet.

I created a table for sales leads with a primary key of LeadID, followed by several columns... (source, name, phone, address, ect..)
I have then created a Data Access Page to match.
I also have a Customer table with a primary key of CustomerID, followed by the same column names as the Lead table, along with a Date column.
I would like to have a button or check box or some other trigger on the Lead's Data Access Page that will copy all the data from that record in the Lead table to the next record in the Customer Table.
In addition, the Date column in the customer table should auto-populate with the date that the copy is performed.

Any information is greatly appreciated.
-Jordan

 

[KenReay]

Hi

See:
DoCmd.RunSQL
INSERT INTO
DoCmd.SetWarnings

in help

if you need more help than that post back

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK