- Joined
- Jun 11, 2004
I have a form in access that I want people to be able to hit a button to copy certain fields to a new record and then fill out the rest
this is the current (default access) code that copies the record
Would the easiest way to accomplish this be, to clear the fields I don't want copied after the paste command? If so how?
Thanks
this is the current (default access) code that copies the record
Code:
Private Sub Duplicate_Project_Click()
On Error GoTo Err_Duplicate_Project_Click
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste
Exit_Duplicate_Project_Click:
Exit Sub
Err_Duplicate_Project_Click:
MsgBox Err.Description
Resume Exit_Duplicate_Project_Click
End Sub
Would the easiest way to accomplish this be, to clear the fields I don't want copied after the paste command? If so how?
Thanks