Good Day Everyone ...

I have a form with various fields on it ... I would like to use the Duplicate Record command button to duplicate similar records ... however, I do not want all the fields to carry over. There are three combo boxes that I would like to have become empty so the user can enter new data with all the other fields remaining the same. Whenever I try to make those fields null after the record has been copied I get the following error ...

"You tried to assign the Null value to a variable that is not a Variant data type"

Here is the code I was trying to implement. Can anyone tell me a better way to do this or how to get around this.

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
Me.cmbSection.Value = Null
Me.cmbType.Value = Null
Me.cmbViolation.Value = Null
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

Thanks - KT