J
jmllr24
Hello,
I appreciate the help in advance. I have a form, "Form A", where a user
enters information into several fields. "Form A" has a subform in it,
"Subform B". "Subform B" also has several fields where a user enters
information.
I then added a command button that is suppsoed to select the record, copy,
and then paste all the data into a new record. However, when the command
button is clicked on information from Form A is copied and pasted. I dont'
know why it is not copying any information from my subofrm B.
The current code I have is the following:
Private Sub Command54_Click()
On Error GoTo Err_Command54_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_Command54_Click:
Exit Sub
End Sub
I appreciate the help in advance. I have a form, "Form A", where a user
enters information into several fields. "Form A" has a subform in it,
"Subform B". "Subform B" also has several fields where a user enters
information.
I then added a command button that is suppsoed to select the record, copy,
and then paste all the data into a new record. However, when the command
button is clicked on information from Form A is copied and pasted. I dont'
know why it is not copying any information from my subofrm B.
The current code I have is the following:
Private Sub Command54_Click()
On Error GoTo Err_Command54_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Exit_Command54_Click:
Exit Sub
End Sub