Validation Rule not working

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.  
mak345Asked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Move your validation to code in the Form_Beforeupdate event procedure.
Then whatever chnages on the form the validation will be re-done.

Pete
0
 
peter57rCommented:
Hi mak345,
You validation rule in B is not going to trigger unless you change the value of B.

Sounds like you need to be doing something in the validation rule for A as well.

Pete
0
 
mak345Author Commented:
Is there any kind of code I can include to trigger the rule?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.