Create a "Record Copy" Button in a form

[pspenn]

Hello all,
I am very rusty in VB and am looking to create a button on a form that makes a duplicate of the previous record and then positions the cursor on a specific field.

This is to be used for entering phone record data where only the phone number will change most of the time.

Any assistance would be appreciated.
Thanks,
Perry

 

[pspenn]

Does anyone know if there is a command to copy a single record? I could figure it out from there...

Thanks,
Perry

 

[PaulF]

there is a duplicate record option in the command button wizard which enters this code:

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


PaulF

 

[pspenn]

Fantastic! Thanks for the pointer... I guess I need to go look at the Wizards better.