Entering multiple new records (nearly identical)

[vangogh228]

One set of users enter sales orders that are pretty simple in nature... Order Number, Item, Quantity, Ship To... etc. They occasionally run across the need to make multiple entries that are identical, because a customer wants the order delivered on a regular time schedule or they want invoiced in increments, etc.

So, they have a need to be able to enter as many as 50 orders, all identical except for the Order Number (and delivery date), all at once. None of these fields is a key field or an autonumber. Order Number is manually entered, though it is indexed - no duplicates. I'd like to create the ability within a form for them to put in a list of Order Numbers, plus the values for the other required entries, and have them populate the source table by applying all the entries to each of the individual Order Numbers.

Any ideas would be greatly appreciated!!!

Tom

 

[whitesmoke]

are they entering the duplicate records one by one? if so just create a duplicate record button.

otherwise you would have to use a loop with addnew on a table recordset having the user specify how many records they want to create.

do until txtval = 50

docmd.addnew

loop

 

[vangogh228]

Whitesmoke:

Curently, yes, they are entering them one at a time. I like the idea of a "duplicate record" button, but they have to manually enter the Order Number. All other information is the same, however.

 

[WrHn85]

Hi,

Julie123's post in the Forms section is similar and has examples, if it helps at all.
http://www.access-programmers.co.uk/forums/showthread.php?t=110467

 

[vangogh228]

Thanks. I'll look at that.

The solution I found was to take the fields you need over and over again and put AfterUpdate code that makes sets the DefaultValue to the entered value, then turns the tab stop off. All fields are required, so they can't miss any. Then, when they enter the one field that will change, and tab forward, all the values in the other fields stay until they close the form. I put OnOpen code on the form that takes it to a new record. That seemed to work to make it so the fields were blank the next time I opened the form (they didn't hold the default from the previous record when the form was opened the last time).