MsgBox to update field. What's next?

[JeffG3209]

Private Sub AMOUNT_BeforeUpdate(Cancel As Integer)

Select Case MsgBox("Are you sure?", vbYesNo)
Case Is = vbYes
Case Is = vbNo

I am brand new to Visual Basic stuff. How would finish the code to allow and edit to be made to a field if "yes" is selected?

[alansidman]

Take a look at this video

http://www.datapigtechnologies.com/f...xinputbox.html

Alan

[JeffG3209]

Take a look at this video

http://www.datapigtechnologies.com/f...xinputbox.html

Alan

That's pretty ironic. I saw another thread with that video on it and I just wrote my first bit of code off of it.

I'll watch again, and then comb through some others.

[June7]

Since you are using the BeforeUpdate event, take advantage of the Cancel argument.
If MsgBox("Are you sure?", vbYesNo) = vbNo Then
'cancel update and return to the AMOUNT control
Cancel = True
End If