Move record and create in another table

Chief

Registered User.
Local time
Today, 08:42
Joined
Feb 22, 2012
Messages
156
Hello,
Access 2010.
I have a table that is tblLead... a form associated with same.
On the frmLead I have a button that when I press I want the record to move to the tbleClients and associated form.

How do I do this??
I have attached screen shot of tables and forms for your information.

Appreciate the help.
Thank you
Jason
 

Attachments

  • LeadBtn01.jpg
    LeadBtn01.jpg
    61.2 KB · Views: 143
  • LeadBtn02.jpg
    LeadBtn02.jpg
    86.6 KB · Views: 158

Users who are viewing this thread

Back
Top Bottom