This is a very simple approch to check to see if a field is blank or filled. I am having problems with the storeit section at the end. I want to test if its blank/empty first. Then to see if it contains a "Yes" or a "No".

The Yes will have it check another field to make sure it contains something. A No will be ignored. Can anyone show me how to do this using the format I have.

Sub Blankit()
Stophere=0
If UserProperties.Find("Application").Value = "" then
Msgbox"Application field cannot be blank. Try again",vbCritical
Stophere=1

ElseIf UserProperties.Find("projectnum").Value = "" then
Msgbox"Project Number field cannot be blank. Try again",vbCritical
Stophere=1

ElseIf UserProperties.Find("phone").Value = "" then
Msgbox"Telephone Number field cannot be blank. Try again",vbCritical
Stophere=1

ElseIf UserProperties.Find("typechange").Value = "" then
Msgbox"Type of Change field cannot be blank. Try again",vbCritical
Stophere=1

ElseIf UserProperties.Find("storeit").Value = "" then
Msgbox"Stored Procedure field cannot be blank. Try again",vbCritical
Stophere=1

Else
If UserProperties.Find("storeit").Value = "Yes" then
If UserProperties.Find("storename").Value = "" then
Msgbox"Stored Procedure Name field cannot be blank. Try again", vbCritical
Stophere=1
End if
End If
End if

If stophere=0 then
'Call store2
'Call Forward1
End if
End Sub
'-=-=-=-=-=-=-