Validation Rule not working
Posted on 2006-07-04
I have 2 text boxes on a form. One text box (B) has a validation rule (a DLookup formula) based off the value in itself and the other (A). If I input values in A and B, the validation rule works. However, if I go back and change the value in A that is not valid, nothing happens. I want it to do some kind of requery where it would pick up this error in the validation rule in B. I know requery works for Dlookups in control sources, but it does not seem to work for Validation Rules.