Reset Combo Box

[Thinh]

How do you reset a combo box to the state when you open the form?
I have a few combo box that are required fields. I know it works if i set combobox = empty but that will allow user to by pass the required fields criteria.
and when i set to Null it says this field cannot be null. if i enable allow null string that will defeat the purpose of required fields.

 

[KenHigg]

Have you tried setting it to ""?

 

[ezfriend]

I would probably create a sub routine to reset these comboboxes to the default state and just call that sub routine whenever I need to.

Private Sub ResetComboBox()

   cboBox1 = "A"
   cboBox2 = "B"
   cboBox3 = "C"
   cboBox4 = "D"
   cboBox5 = "E"

End Sub

Peace,

EZ