Solved

Validation Rule not working

Posted on 2006-07-04
3
217 Views
Last Modified: 2008-03-03
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.  
0
Comment
Question by:mak345
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
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
 

Author Comment

by:mak345
Comment Utility
Is there any kind of code I can include to trigger the rule?
0
 
LVL 77

Accepted Solution

by:
peter57r earned 25 total points
Comment Utility
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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now