Copy a record from one table to another

[GussyBoy]

I have a table with a few fields one of the fields being a combo box. This combo box is used to select the record that i want shown on the form. After selecting a record, I want to use a command button to add/copy the current record to another table. Is this possible? I've tried building a query but I can get the coding right for the criteria for the combo box. Please advise.

Thanks.

 

[Zygor]

Are you using a form based on the table?

 

[GussyBoy]

Yes I am.

 

[Zygor]

Does your dropdown include the Primary Key of the table? (It can have a length of 0 so it isn't shown.)

 

[GussyBoy]

Yes. My dropdown combo box is the primary key field in the table.

 

[Zygor]

Use an append query to append the one record to the other table using the primary ID as your criteria.

 

[GussyBoy]

How do you reference the primary ID for that form in the criteria section of the query?

I've tried =[formname].[objectname] but that didnt work.

 

[Zygor]

something like (untested)
"INSERT INTO Table2( [ID] ) SELECT [Table1].[Field1] FROM [Table1] WHERE ((([Table1].ID)='" & forms!formName!column(0) & "'));