Copying Records from a form to a table

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
Hey Andrew !

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

John
 
Back
Top