How to add multiple records where only the number changes

[tagteam]

My boss wants to be able to add multiple records where only on of the fields will change. This is a repair record and in this scenario all the work done to the cars is the same. Same date, same place, same time etc. The only thing that changes is the car number



I would like to create a for that will allow him to enter all the information for place, date, cost, etc and then a field that will allow him to select a car from the dropdown and select add to list. He could then keep going and add as many cars to the list as he wants.

Are the any ideas how to do this or any better suggestions.
Thanks for any help,

[June7]

Use code to set the DefaultValue property of each textbox with the entered value. This value will carry forward to next record when it is initiated by selecting the car. The value will be retained until another edit or the form is closed.

[tagteam]

I may not have explained myself clearly. For each group entry the value of the place, amount, date etc will change with each group entry. Your idea would work if I could create a form that autofills all the values from the last record. Then my boss could just change the car number after he has entered all the other information. Is there an easy way to do that?

[tagteam]

Can a Dlookup be used for this? I am not sure how this would work because I would only want the Dlookup to work after the first record has been saved.

[June7]

My suggestion is to open form, enter data into a record, code will set the DefaultValue property of each control. Move to new record row, select the car, all the other fields will automatically populate.

If you want the DefaultValues to be set with data from an existing record when the form opens, that can also be done with code.

[tagteam]

Thank you, I looked on the internet and found Allen Brownes code at allenbrowne.com/ser-24.html and with this I was able to accomplish what you are talking about.