Message Box when data has been deleted in a field

[scoe]

I have a field that has a default value of 0.... Only values between 0 and 100 can be used. At present if 101 is input the message comes up but if the field data is deleted no message shows. I have tried numerous permitations and am at a loss so would be grateful of any help in this matter.


The code I have at the moment is in the Lost focus of the [POD] filed:
[If [POD] = "" Then
MsgBox "Incorrect Value Please select a value from the Drop Down List"
End If]

Many thanks

[pbaldy]

Options include making the field required in the table and:

http://www.baldyweb.com/BeforeUpdate.htm