Validation Rules

[jcaptchaos2]

Can you set a validation rule to look at a list of numbers that a query created or look to see if it is in a list of numbers ina table? I have a table that has a list of numbers in one column and then there is another column that states if the the number can be used "Yes" or "No" in that column then an if statement in the last coulmn that says (if "Yes" leave blank if "No" place the number from the first column. I created a query that only pulls the numbers that contain a "NO" in the same row to see if I could tie it to that but am having troubles. I need a validation rule that looks at the table or query.

 

[John Big Booty]

In the Before Update event of the field you could use the DLookup() function to compare the value in the field with the values in your table/query.

 

[jcaptchaos2]

Hey thanks Booty I will give that a try.