I got kind of dizzy, trying to follow the ins and outs of your explanation, but if you want to enter Multiple Records, one following the other, where the only difference in each Record is the Employee's name, you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.
Code:
Private Sub YourControlName_AfterUpdate()
Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub
You’ll need to do this for each Control that you want to ‘carry forward.’
Note that this code/syntax can be used for any Datatype.
Another approach for this kind of thing would be to have a separate ProjectEmployees Table, related to the Projects Table by a ProjectID Field, that’s present in the Projects Table as the Primary Key and in the ProjectEmployees Table as a Foreign Key. You’d then create a Form for each Table, with all the project info in the Projects Table/Form, and have the ProjectEmployees Form displayed as a Subform on the Main, i.e. Projects Form.
Linq ;0)>