Copy Record

[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.

 

[John Vinson]

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.

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]