Ab-normalization at Experts Exchange - part 5

The question today:
Access 2007 form validate field based on result from query

Reading the question you find a questioner wanting to check or an entered field equals the result from a query +1
In case there's a difference the user should be warned and, when possible, given the value to be entered.

This is a real "classic" example of redundant data. Everything that can be extracted from the database with query shouldn't be stored, so you would expect that an "expert" would advise not to store this and use the result of the query to show the actual value of the field as information.

Well, you're having a bad day when you're advised by the #1 MS Access expert at Experts-Exchange. This "expert" will give you as solution the code with a working IF statement and won't mention the data redundancy...

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23961889.html)