Field value on form stored in two different tables

Hi!
I need some help. I have a database with some forms and tables. on Form1 on Table1 i need to put one field (Field1) whose content has to be stored in the corresponding line in Table1 and copied in a new line of Table2, also copying data from Filed2, Field5 and Field7, plus i need to add two fields (Field9 and Field10) tho fill up the related fields in Table2.

Is this possible? i'm quite a rookie in access and access vba, so any kind of help (except creating a subform) would be great.
thank you!