I have used the wizard to create a Duplicate Record command button on a
form. It works fine for a single duplicate but if I want to duplicate
an additional record I receive an error:
"The command or action 'Paste Append' is not available right now."
I have to close out of the form and reopen to get the button to work
again. A bit of a nuisance.
Any suggestions.
Below is the code the wizard has written - much thx for any
suggestions...
Private Sub Duplicate_Click()
On Error GoTo Err_Duplicate_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste
Append
Exit_Duplicate_Click:
Exit Sub
Err_Duplicate_Click:
MsgBox Err.Description
Resume Exit_Duplicate_Click
End Sub