Working in Access 2003.
I have managed to duplicate a record using a button on a form with code:
But this just creates a duplicate of the fields on the form, which is fine, but i would also like to +1 to one of the fields on the new record.
Is this possible? If so how would i do it.
Also.....
If this is possible,
would it also be possible to have a drop down menu in which to select say (n)1-9 and that is how many duplicates it will make with field +(n).
so the first duplicate will be the same but a field will have +1, and the next +2, etc.
for the selected number of fields
I have managed to duplicate a record using a button on a form with code:
Private Sub Command16_Click ()
On Error GoTo Err_Command16_C lick
DoCmd.DoMenuIte m acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuIte m acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_Command16_ Click:
Exit Sub
Err_Command16_C lick:
MsgBox Err.Description
Resume Exit_Command16_ Click
End Sub
On Error GoTo Err_Command16_C lick
DoCmd.DoMenuIte m acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuIte m acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_Command16_ Click:
Exit Sub
Err_Command16_C lick:
MsgBox Err.Description
Resume Exit_Command16_ Click
End Sub
But this just creates a duplicate of the fields on the form, which is fine, but i would also like to +1 to one of the fields on the new record.
Is this possible? If so how would i do it.
Also.....
If this is possible,
would it also be possible to have a drop down menu in which to select say (n)1-9 and that is how many duplicates it will make with field +(n).
so the first duplicate will be the same but a field will have +1, and the next +2, etc.
for the selected number of fields
Comment