doesn't work Y??

[raven123]

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

[reeset]

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:

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

text1.value=mytext

Instead you can use either one of the following

text1.text=mytext

'or

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

Hope this helps.

[kedaman]

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

[raven123]

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 = ""

[kedaman]

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