[ginaw]

I created a button on my input form to duplicate record. This works fine but I want the record to duplicate and then clear the start date and end date for new entry. Does anyone know how I can do this?

[OBP]

Are you using a "Macro" or VBA code?

[ginaw]

OBP,

I created a button with the button wizard that Duplicates the Record. It is a Macro. But if there is a better way in VBA than please let me know.

[OBP]

Normally the Button Wizard uses VBA code, which is why I asked, it is simple to add a bit of code on the end to clear the 2 fields.

[ginaw]

I have uploaded a snapshot of the embedded macro. Can you help me around this? Or should I add VBA code somewhere?

[OBP]

What is the name of the button?
What are the actual names of the 2 fields that you want to clear?

[ginaw]

OBP,

The name of the button is Duplicate Record. The 2 fields are DateStart and DateEnd.

[OBP]

Try this in the On Click Event Procedure
On Error GoTo Err_Duplicate_Record_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
me.DateStart = ""
me.dateEnd = ""

Exit_Duplicate_Record_Click:
Exit Sub

Err_Duplicate_Record_Click:
MsgBox Err.Description
Resume Exit_Duplicate_Record_Click

[ginaw]

OBP,
The Embedded Macro is on the 'On Click' event on the Duplicate Record Button.

[ginaw]

OBP,

I replaced the macro with the code above and it worked!! You are awesome!! As always!!

Thank you.

[OBP]

Sorry, I should of explained that you needed to replace the macro. Well done figuring it out.