Validation override

[Mr. E.]

Is it possible to set up a validation that asks you to double check your
entry without restricting you from entering that data (number field)?
I am currently using excel which allows you to override the validation if
you set it to a warning. I can't seem to find the same feature in access. I
use this when a student correctly answers bonus questions to get a mark above
100%.

Mr. E.

 

[Rick Brandt]

Is it possible to set up a validation that asks you to double check
your entry without restricting you from entering that data (number
field)?
I am currently using excel which allows you to override the
validation if you set it to a warning. I can't seem to find the same
feature in access. I use this when a student correctly answers bonus
questions to get a mark above 100%.

Mr. E.

Instead of a validation rule perform your test in the BeforeUpdate event of the
form.

If (some test) = False
If MsgBox("Are you sure",vbYesNo) = vbNo Then
Cancel = True
End If
End If

 

[Mr. E.]

:

Instead of a validation rule perform your test in the BeforeUpdate event of the
form.

If (some test) = False
If MsgBox("Are you sure",vbYesNo) = vbNo Then
Cancel = True
End If
End If

Thank you Mr. Brandt. You have been most helpful.

Mr. E.