Hi all, and thanks to all those that have helped thus far, I have another issue. I have this on the before update in a field to monitor changes to prompt the user that they have made a change and to make sure the change is correct.
Const MESSAGETEXT = "Do you wish to make changes to the Status?"
Beep
If MsgBox(MESSAGETEXT, vbYesNo + vbQuestion) = vbNo Then
Cancel = True
Me.Undo
End If
I would like this to only appear if the 'status' changes to certain words. ie. 'Disposed', 'sold' etc.