Access completing records

[Maxlond]

I have a question for my form in Access which it generates to Excel, but before that I would like to use the button complete in the form to complete the records from the first to the last in the field "Field3" with data from "Kombi8". I tried to apply

Please Login or Register  to view this content.

But the macro only works on the first record. Thank you in advance for the answer.

In the attachment I have included a macro in the form