Msgbox

[Mechele]

What value does the Reponse Field have if the user clicks the No button? Is it the number 7 or something else?

Private Sub SocialSecurityNumber_LostFocus()
Response = MsgBox("Is your Security Number Correct?", vbYesNo)
If Response = 7 Then
Me!SocialSecurityNumber.Enabled = True
End If
End Sub

 

[IfButOnly]

I'm not sure of the value of response but try:-

if response = vbNo then....

(same for vbYes, vbCancel etc)

 

[paulmcdonnell]

Yep "VBno" is the way!