Copy Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is taking in inventory records. If the user would like to
add the same inventory item twice is it possible to copy the entire record,
save the record (DoCmd.RunCommand acCmdSaveRecord), move to the next record
(DoCmd.GoToRecord , , acNewRec), then paste the previous record in. It needs
to be this way because all inventory records need to have a separate sku
number for dating purposings. Thank you.
 
I have a form that is taking in inventory records. If the user would like to
add the same inventory item twice is it possible to copy the entire record,
save the record (DoCmd.RunCommand acCmdSaveRecord), move to the next record
(DoCmd.GoToRecord , , acNewRec), then paste the previous record in. It needs
to be this way because all inventory records need to have a separate sku
number for dating purposings. Thank you.
Click to expand...

An Append query appending one record, using the current form's ID, is
probably simplest here. Alternatively, you can set each control's
DefaultValue property to the current value of the control in its
AfterUpdate event so that new records will automatically ditto the
previous record.

John W. Vinson[MVP]
 
Back
Top