copying specific record to a new record

G

Guest

I have an order form for creating/editing new records.
However it often happens that we have 10 identical orders, each order being
a seperate shipment. My order id mask is 00000-0, the trailing -0 represents
the shipment number for that order. So the first load would be -1 2nd load
would be -2.

Is there anyway to copy the 1st shipment and have it automatically create
the remaining loads(-2,-3,-4 etc.) as many times as we push the button, that
way the end users don't have to re-enter all the same information multiple
times.

Thanks!
 
G

Guest

Put a command button on your form to call an append query set to append only
one record based on the current record.
Use the following for the OrderID field --
Left([OrderID],6)& Val(Right([OrderID],1) + 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Form to a new record 4
H E L P - Problem with 'related' table - no new record is created - why ? 2
check out a record 1
Process update query in specific order 2
copying specific record fields to a new record 7
VBA code to load a form with specific record 5
New "copied" record doesn't gain autonumber 9
Form automatically adds new record 2

Top