Validation Rules

[esglover]

Hello,

I am making a database that is used to enter Quality Control data. In order to prevent erroneous entries, I am setting up validation rules (for example the measured pH has to be between two certain values). This is easy enough to do when those numbers are fixed, but I want those to be able to be changed easily. Since there are several tables that have the same bounds, I want to have one place where they can be changed and have it update to all of the necessary tables.

For example, I tried making a Bounds table with fields such as pHMin, pHMax, etc. I want the validation rule to be able to say something like:

"Between Bounds.pHMin and Bounds.pHMax"

Then when I go to the Bounds table I can put in any value I want for pHMin and pHMax and have that validation rule use those values. Unfortunately, this doesn't work. Is there a way to get Access to do this? Thanks in advance for your help.

[RuralGuy]

My preference for validation is to *always* perform it at the FORM level. I never use a table level validation. You can use the BeforeUpdate event of a control to validate in any way you choose. You also have far more control over the error messages displayed to the user at the FORM level.