I have this code in the BeforeUpdate event of a combo box:
Private Sub MonthID_BeforeUpdate(Cancel As Integer)
UserResponse = MsgBox("Is " & MonthID.Column(1) & " the correct month?", vbYesNo, "Correct Month")
If UserResponse = vbNo Then
Cancel = True
I get this error:
You must save the field before you execute the SetFocus method.
So I put this code in the AfterUpdate event
And got the same error.
My objective is that if everything is OK move the focus to the next control, YearID