Need a pop up warning to appear when data entered is not in a specified range.

[Sightly]

I have a table with a list of parameters and the ranges these parameters should be in. I have a form that is going to be used for daily checks to make sure everything is running in these parameters and I want to have a pop up message appear if something is out of the range. I think I could use an event update on the box to check but I don’t know how to have it compare to values in another table. Any help would be greatly appreciated!!

[kd2017]

Can you define your table structure? How your fields/rows are actually constrained isn't quite clear. You would normally just use validation rules https://codekabinett.com/rdumps.php?...alidation-rule

[ranman256]

something like:

sub txtBox_afterupdate()
ValidateDataRange txtBox
end sub


sub ValidateDataRange(pvVal)
select case true
   case  pvVal < Dlookup("[LowVal]", "table")
        msgbox "Value is too low",,"out of range"

   case  pvVal > Dlookup("[HighVal]", "table")
        msgbox "Value is too high",,"out of range"
end select
end sub