Unanswered: Can anybody find a problem with this code?
Here's some code I generated that is supposed to present a user with a yes/no choice before overwriting a field.
Specifically, I am looking for problems with the IF and MSGBOX portions. I dunno if i have too many if's in there or what but when i go to click the button, it doesn't do anything! nada...
Thanks in advance for your consideration!
Private Sub UpdateAmendment_Click()
On Error GoTo Err_UpdateAmendment_Click
If Forms![Contract Maintenance Form]![Maintenance Form subform].Form![Amendment/Contract] <> "" Then
If MsgBox("Scanned contract already exists! Are you sure you want to replace it?", vbYesNo) = vbYes Then