How do I insert data into a table that is NOT the

[dalynching]

How do I insert data into a table that is NOT the Record source for the form. I have a customer form that is linked to the customers table. I want to take the first and last name fields from this form and also enter them into the clients table for later use. Thanks in advance.

Dalynching

 

[Trendsetter]

Open a recordset with

dim rs as Recordset
set rs = CurrentDb.openRecordSet("tblCustomers&quot
rs.AddNew
rs!FirstName = Me.FirstName
rs!LastName = Me.LastName
rs.update
rs.close
set rs = Nothing