We're entering in part measurements, and I have a "OutOfSpec" field setup to indicate when a part is outside its tolerance range.
I'm trying to figure out the easiest way to set the "OutOfSpec" field when a value in another field is outside the tolerance ... is there a way to update a field when a conditional format is triggered? It seems like a waste to add VBA and do all tolerance checking again before inserting/updating the record when it's already done once with conditional format.