Copying Records from a form to a 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

 

[John Henriksen]

Hey Andrew !

make an append query that append to your tabel using an unik key ( the unik
key on the search form)

John