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