Duplicating part of a record


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

Advertisements

R

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
 
G

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
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top