Hi,
I'm using Access 2010.
I'm trying to check the value in a combo box when the user tabs off it to make sure something WAS selected [it can't be blank].
I've got this code:
Code:
Private Sub cmbDestroyMonth_AfterUpdate()
Forms!Master!cmbDestroyMonth.SetFocus
If Forms!Master!cmbDestroyMonth.Value Is Null Then
in the After Update event of a Combo Box.
Previously - I had this I simply had:
Code:
Private Sub cmbDestroyMonth_AfterUpdate()
Me.cmbDestroyMonth.SetFocus
If Me.cmbDestroyMonth.Value Is Null Then
Either way - when I select a value from the list - I get an 'Object Required' error.
I'm not sure I understand what the problem is.
I'd appreciate any help I can get.
Thanks!
Robeen