Hi -

I created a combo box with 4 values.  I do not want to allow data entry if the combo box is EMPTY or if DOES NOT contain one of the 4 approved values.  

I tried the following code:

	If @IsBlank(Status)
		or not status = "deceased"
		or not status = "incomplete"
		or not status = "info only"
		or not status = "reunion"
		{
		NotifyForm(1) // Prevent save
		@MsgBox("You must enter one of the following values!","","Deceased or Incomplete or Info Only or Reunion")
		Goto Status
		}
	Else
		{
		NotifyForm(0) // Allow Save
		} 

If the combo box is empty, I get the desired results; however if I enter ANY VALUE in the combo box field, I do not get an error message.

Since ANY of the 4 values would be acceptable, I first tried using "and not" instead of "or not"; however, I do not get an error message in that case either (unless the status box is empty).

What am I doing wrong?

Mark -

To be perfectly truthful, even though my programing was far more "clutzier," I still do not understand why it wouldn't work.  But I am not even going to worry about that, because your suggestion was right on! ... and why "argue" with success?!

It works like a charm and you saved me a lot of grief.

Also, I remembered that I'm not supposed to use "goto" so I changed it to "throwfocus" and that too works just like I want.

Thanks very much!!!

Ben -

Thank you so much for addressing my first code.  I really appreciate it.

I knew the logic was incorrect with regard to the possibility of it meeting one condition (of the four possible choices .... which would then automatically mean it didn't meet the othere three) but just wasn't hitting on the right approach.

Your explanation is crystal clear and a very big help.