required field IIF

  • Thread starter Thread starter Donny
  • Start date Start date
D

Donny

On my form I have a field that is a Combo Box (1,2,3,None) If None is not
picked I want another field (Estimated Total Field Hours) to be required.
Fairly new user.
Thanks in advance!
 
Thanks, I'm alot closer now. I modified the code slightly to return a not
equal to "None" but I'm receiving a " Run time error '2108' You must save the
field before you execute the SetFocus method" Her is my modified code. Any
suggestions would be appreciated.
Thanks
Private Sub Priority_BeforeUpdate(Cancel As Integer)
If Me.Priority <> "None" And IsNull(Me.[Estimated Total Field Hours]) Then
Cancel = True
MsgBox "If Priority is a 1,2 or 3 then 'Estimated Total Field Hours' must
be filled in!"
Me.[Estimated Total Field Hours].SetFocus
End If

End Sub
 
Back
Top