Yes/No on Change

  • Thread starter Thread starter klr397
  • Start date Start date
K

klr397

I have a last field name that i need to have a msgbix come up and keep the
user from accidentily wipeing out the last name field. however i am
completly stuck on my code.

Private Sub LastName_Change()
Dim Answer As Integer
Answer = MsgBox("Do you wish to change this candidates Last Name?",
vbQuestion + vbYesNo, "Question")

If answer= VbYes Then

Else

End If

End Sub

Any one want to fill in my if statement it would be much apreciated
KAtie
 
Back
Top