auto populate and move data for inventory db

Q1. I need to populate my table by entering starting sequence and populate data by indicating how many pieces or items to add.

E.g. I will enter starting sequence 301 in a field and 100 as pieces on another field and AfterUpdate should be able to populate my table (tbl1) with 301 to 400 series.

Q2. I need to move data from one table (tbl1) to another table (tblStockOut) by entering starting sequence of items to move and ending with last sequence.

e.g. I will enter starting sequence 340 on the FROM Field and sequence 359 on the TO Field and AfterUpdate should move sequence 340 to 359 to tblStockOut leaving 301 to 339 and 360 to 400 series in tbl1.

i’m using ms access 203.

hope somebody can help.