Need help moving record from table1 to table2

[SuperNerd]

I have two table, tbl1 and tblScrap. I created a form that lets the user
input in all the needed information and within the form, I have a checkbox.
All the input information will go into the tbl1.

When a checkbox is marked or checked, I want the record that has the
checkbox marked to be moved from tbl1 to tblScrap; this way I can keep track
of all the scrap materials in the tblScrap. thanks in advance for any help.

I would prefer to use module over SQL

 

[pietlinden]

I have two table, tbl1 and tblScrap.  I created a form that lets the user
input in all the needed information and within the form, I have a checkbox.  
All the input information will go into the tbl1.

When a checkbox is marked or checked, I want the record that has the
checkbox marked to be moved from tbl1 to tblScrap; this way I can keep track
of all the scrap materials in the tblScrap.  thanks in advance for any help.

I would prefer to use module over SQL

What's wrong with adding a single column to tbl1 indicating whether
the item is scrap or not? Then you would just update a single record
with a simple update statement. Personally, I would use SQL first and
a module only if there is no other option. SQL is set based, so
infinitely faster than modifying a record at a time. Try a test with
100K records sometime...