adding a selected record to a new table

[Andrew]

I make a form with the form wizard using all the fields from my table named
frmSearch

I then make a combo box in the header that finds a record on my form based
on the selection in the combo box - cmbSearch

I have a command button that I want to append the current record to a new
table but i dont know what code I need on the on_click event to do that.

Thanks in advance