In the Storeit field I am looking for a Yes or No. If they enter a No, I want it to proceed. If they enter a yes then I want it to check the storeage2 field for data. It cannot be left blank so I want it to stop at this time until they enter data. Not sure how to go about this. Is this enough information?

Sub Blankit()
Stophere = 0
If UserProperties.Find("Application").Value = "" then
Msgbox"Application field cannot be blank. Try again",vbCritcal
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("storeit").Value = "Yes" then
If UserProperties.Find("storage2").Value = "" then
Msgbox"Stored Procedure field cannot be blank. Try again", vbCritical
Stophere = 1
End if

ElseIf UserProperties.Find("reqdate").Value = "" then
Msgbox"Date Requested field cannot be blank. Try again", vbCritical
Stophere = 1

Else
If UserProperties.Find("typechange").Value = "" then
Msgbox"Type of Change field cannot be blank. Try again",vbCritcal
Stophere = 1
End If
End if

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