J
Judi
I would like to be able to copy a record and then give the user a message box
to fill in one field on the form, specifically, revision number.
Can anyone help me with this? I have the button already which copies and
pastes a new record, but I want to make sure that the user will enter a
number in this revision field... if I don't make it default, they may forget
to do this key part.
Here is the code I have already, it was created with the command button
wizard:
Private Sub btnCopyForRev_Click()
On Error GoTo Err_btnCopyForRev_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_btnCopyForRev_Click:
Exit Sub
Err_btnCopyForRev_Click:
MsgBox Err.Description
Resume Exit_btnCopyForRev_Click
End Sub
If anyone can give me the information I need, I would be grateful. Please
don't just give me code, I want to know what I'm doing so I can learn, not
just blindly copy and paste and accept that it works.
Thank you all!!
to fill in one field on the form, specifically, revision number.
Can anyone help me with this? I have the button already which copies and
pastes a new record, but I want to make sure that the user will enter a
number in this revision field... if I don't make it default, they may forget
to do this key part.
Here is the code I have already, it was created with the command button
wizard:
Private Sub btnCopyForRev_Click()
On Error GoTo Err_btnCopyForRev_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_btnCopyForRev_Click:
Exit Sub
Err_btnCopyForRev_Click:
MsgBox Err.Description
Resume Exit_btnCopyForRev_Click
End Sub
If anyone can give me the information I need, I would be grateful. Please
don't just give me code, I want to know what I'm doing so I can learn, not
just blindly copy and paste and accept that it works.
Thank you all!!