Experts, how can I undo what was selected if user selects NO? I was assuming that in a vbYesNo if user selects No then it wont change the value of the combo box but it changes it independent of whether user selects Yes or No.
(I might also need to account for whether or not the record is new but maybe by saying Not is Null then that handles it)
Private Sub cboLCType_BeforeUpdate(Cancel As Integer)
If Not IsNull(Me!cboLCType) Then
MsgBox "Are you sure you want to change the LC Type?", vbYesNoCancel