doesn't work Y??

here's the code

If LCase(sev.value = "1" or sev.value = "2" or sev.value = "3") _
AND NOT LCase(onformopen.sev = "1" OR onformopen.sev = "2" OR onformopen.sev = "3") then
Enotify.value=""
End If
End Sub

I still get an error on this Y

There are a couple things that I see. First, you would not use LCase for a numeric. If you need to check for numbers, use the isnumeric function like:

Code:

---


If isnumeric(myvalue)=true then
  msgbox "it is a number"
Else
  msgbox "not a number"
end if

---

Secondly, I am assuming that you are using TextBoxes. To
get the text inside the textbox box, you don't use

Code:

---


text1.value=mytext

---

Instead you can use either one of the following

Code:

---


text1.text=mytext

'or

'The reason why this works is that .text is its default
'property.
text1=mytext

---

Hope this helps.

Lcase is used with strings, not boolean variables, but i don't know what you mean with Y

thanks for your help, but I don't want to use a message box. It so whent he user comes in and checks either 1,2,3 then in the email field in will pick up DEV. If the user comes back into the form and the severity is already 1,2,3 then email will be = ""

I guess you could just remove Lcase but leave the ()