So, I've noticed when we use a duplicate record command button, the new duplicate record is missing one specific field [Marker Lights] data .
Any suggestions on how this could happen?
Duplicate Record command button does the following:
Code:
Private Sub cmdDup_Click()
On Error GoTo Err_cmdDup_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 'acCmdSelectRecord
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 'acCmdCopy
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Model = Model & " DUP"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'acCmdSaveRecord
Combo109 = Null
Model.SetFocus
Exit_cmdDup_Click:
Exit Sub
Err_cmdDup_Click:
MsgBox Err.Description
Resume Exit_cmdDup_Click
End Sub