Yes/No on Change

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top