G
Guest
Hello,
I have a data entry form used to populate a table. There are about 25 fields
to fill in. The operators sometimes have two records that are almost
identical - except for the order number (primary key) and a few dates. Is
there a way to program a button to duplicate the record, except for the order
number and dates, then prompt to enter the new order number?
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 it duplicates the entire record, then I get an error for a duplicate
primary key.
Thanks,
I have a data entry form used to populate a table. There are about 25 fields
to fill in. The operators sometimes have two records that are almost
identical - except for the order number (primary key) and a few dates. Is
there a way to program a button to duplicate the record, except for the order
number and dates, then prompt to enter the new order number?
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 it duplicates the entire record, then I get an error for a duplicate
primary key.
Thanks,