copying specific record to a new record

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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
 
Back
Top