VBA Code for Is Not

Hello,
>
I'm trying to add some data validation to the BeforeUpdate event of a
form. I want the user to select a number between 1 and 3 for the
[Choice] field. Can I use something like IsNot? Sorry, a little
rusty here!
>
Thanks
>
=====================
>
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Data validation to ensure a choice number between 1 and 3 is
selected.
If IsNot (Me.Choice (>=1 And <=3) Then
MsgBox "Please select a choice number between 1 and 3.."
DoCmd.CancelEvent
Me.Choice.SetFocus
End If
>
>

"WPW07" <wwisnie...@gmail.comwrote in message
>
news:547f7eb1-f441-42bb-b104-1023dc4a9456@8g2000hse.googlegroups.com...
>
>
>
>
>>>>>>
Replace IsNot with Not
>
*iif(not (True),"Not False","Not True")- Hide quoted text -
>
- Show quoted text -

On Mar 14, 3:39 pm, "paii, Ron" <n...@no.comwrote:
>
>
>>>>>>>>>>>
Why not use Me.Choice as a combo Box. Make it so that you cant type
anything there in KeyPress method : AcsiiCode = 0. And have the
options available obviosly having a default option.
>
- GL

Hello,
>
I'm trying to add some data validation to the BeforeUpdate event of a
form. I want the user to select a number between 1 and 3 for the
[Choice] field. Can I use something like IsNot? Sorry, a little
rusty here!
>
Thanks
>
=====================
>
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Data validation to ensure a choice number between 1 and 3 is
selected.
If IsNot (Me.Choice (>=1 And <=3) Then
MsgBox "Please select a choice number between 1 and 3.."
DoCmd.CancelEvent
Me.Choice.SetFocus
End If
>