Clear Numeric Combo Box

[by32]

All,

I have a checkbox and a few combo boxes in a form. I have set up the form to where the combo boxes are locked until the check box is checked (Value = -1). What I am trying to set up is that if the user un-checks the box, the values in the combo boxes (and the related table) will be erased.

The combo box bound column is a primary key that writes to a related table as a foreign key.

My problem is, how do I clear the combo box contents when the value stored is a number?

I tried cmbExample.Value = Null and
cmbExample.Value = Nothing

Both error out. Is there any easy way to clear the combo box when a number value is stored?

Thanks in advance...

 

[John Big Booty]

Try;

Me.ComboName = Null

 

[CharlesWilliams]

Or you could try Me.ComboName = ""