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?
--
tash

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


"tash" <(E-Mail Removed)> wrote in message
news:5683C158-4EB4-451E-9F3D-(E-Mail Removed)...
>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?
> --
> tash

On Tue, 6 Nov 2007 22:14:01 -0800, tash <(E-Mail Removed)>
wrote:

>Can this be done using the field validation rule or not?

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]