Duplicating part of a record

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

Guest

Hello,

I have a form used to populate a table. Operators occassionally need to
duplicate most of the information of a record they just entered (ie -
excluding the order number, which is the primary key in the table, and
various dates). How can I select specific fields to duplicate, then allow
them to fill in the others?

Thanks,
 
Using code? At the click of a button? Automatically?

If they want to copy the previous record, then can press CTRL-' in each
field that they wish to copy. If you had something else in mind, you'll
have to tell us what your plan is.

Rick B
 
Hi Rick,

Yes, using code and clicking a button. I tried a command button using:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

but obviously that doesn't work because it duplicates the entire record,
then I get an error for a duplicate primary key.

Sorry for not being more clear.

Thanks,

Marc
 
Any new ideas out there?

Thanks,

Marc

Marc said:
Hi Rick,

Yes, using code and clicking a button. I tried a command button using:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

but obviously that doesn't work because it duplicates the entire record,
then I get an error for a duplicate primary key.

Sorry for not being more clear.

Thanks,

Marc
Click to expand...
 
Back
Top