?
Solved

Validation Rule not working

Posted on 2006-07-04
3
Medium Priority
?
260 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 17036986
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
ID: 17037079
Is there any kind of code I can include to trigger the rule?
0
 
LVL 77

Accepted Solution

by:
peter57r earned 100 total points
ID: 17037691
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

765 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