Adding addition records without overwriting existing records

[ozzy68]

I have a form with several combo boxes that I use to select specific data to add to a table. I need to have that data saved as a new record without overwriting the existing record...can somebody please assist?

 

[jdraw]

do research on INSERT SQL or APPEND query

http://www.w3schools.com/SQL/sql_insert.asp
http://www.techonthenet.com/sql/insert.php

http://office.microsoft.com/en-us/a...ble-by-using-an-append-query-HA010076526.aspx

 

[ozzy68]

I was able to work with that suggestion, thanks!