Insert record from table into different table

[tpcervelo]

I want to add a selected record from Table1 to Table2. Table1 is displayed to the user in a split form with a Command button for adding records. When the user finds the correct record clicking the button should add only that record to Table2. I have written an append query for the fields I want. On the event I have a DoCmd.Openqery (I have also considered a DoCmd.RunSQL). Howeve, I cannot figure out how to only insert the current record.
Thanks for any help...

[pbaldy]

I haven't used split forms, but try adding a criteria to your query that references the form:

INSERT INTO...
SELECT...
FROM...
WHERE KeyFieldName = Forms!FormName.ControlName

[tpcervelo]

Pbaldy,
Thank you very much.
I dumped my SQL code form the query into a string and added your suggestion of the WHERE clause...worked perfectly.
thanks again...

[pbaldy]

Ah good, glad it worked for you.