Allow enty of data outside validation rule without removing rule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am entering biochemistry data which has a normal range. I want to use the
validation rule to alert me when data is outside the normal range, so that QC
can be performed automatically on the data entered. However, I want to be
able to enter data outside of the normal range on second entry if this is the
true value. Can this be done using the field validation rule or not?
 
Wouldn't think so.
You could display a warning in the control's afterupdate event in the form
though

Private Sub Text0_AfterUpdate()
If Access.Nz(Me.Text0.Value,0) > 100 Then
MsgBox "Please check validity of
value",VBA.vbMsgBoxStyle.vbWarning,"Text0"
End If
End Sub

Pieter
 
Can this be done using the field validation rule or not?
Click to expand...

No. Either a field matches the validation rule or it does not; if it does not,
then the value cannot be entered.

Use the BeforeUpdate event on a Form as suggested.

John W. Vinson [MVP]
 
Back
Top