Quick repetitive data entry in form

[scottfrock]

I have a form that contains all the information for a crew of 20 people. All of the information is duplicated, except the units produced and the employee ID. How do I automate the entry process to make all the duplicated information copy from one record to the next, only changing the employee id and units?

[RuralGuy]

See if this link helps: http://access.mvps.org/access/forms/frm0012.htm