Duplicate Records

[Wrecker]

For some reason I can't create a duplicate record. I created the button on the form. When the button is pressed, it copys to the clipboard, but does not paste to the form. Also, when I use the wizard to create the button, the Paste append in the code is jumpperd out(Like a commennt).

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

Thanks
Wrecker

 

[Junior1544]

Tell us exacly what it is you are tring to do and i'll see if i can help... It looks like you tried to convert a macro to vba...

I can't tell what you are tring to do with it though...

Give us your goal, and I'll do my best to give you a solution.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Wrecker]

I'm simply trying to create a duplicate record. I have a form with about 25 textboxes. because only 3 of the textboxes data changes for the next record (the rest remain the same Data), I wanted to create a duplicate , then use code to clear the data in the 3 textboxes. Then the operator can enter data in the 3 boxes that need to change, instead of re entering data in all 25 textboxes.

as I stated earlier, I used the wizard to create a duplicate record button, but it wont "Paste" the data.