Duplicating part of a record

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

 

[Rick B]

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

 

[Guest]

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

 

[Guest]

Any new ideas out there?

Thanks,

Marc

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