Validation Problem

[JPritch]

Greetings from America!

I am attempting to set a validation rule for one field based on the value of the previous field.

I have developed a table that contains insurance policy QA information. The sampled policies that are pulled for QA have their Policy # entered, the processor's name, a *Failed QA Indicator(y/n), and a *Failed Reason Code (drop down box).

Currently, a person can select a Failed Reason code without populating the Failed Indicator field first. Is there a way to set a validation rule or other, that would prevent somebody from selecting a Failed Reason Code without first marking the Failed Indicator box as Y?

I can't seem to set a validation rule that points to another field.

 

[JPritch]

Where do I find the form's "current event" to enter the code?

 

[JPritch]

Thanks for the help PH!

The logic works as intended. I have encountered one problem though...when the Failed_Indicator box is selected and then deselected, I receive the following error message:

Run Time Error '2165'
You can't hide a control that has the focus
-END -DEBUG

When I click the debug button, the ME.Failed_Indicator.Visible = False is highlighted.

Any ideas on how to fix so that you can select and then if necessary deselect Failed_Indicator without receiving an error?

 

[JPritch]

Pat,

My fault. I entered Failed_Indicator when I should have entered Reason_Code. Your logic works great (when I actually enter it correctly!).

Problem solved!

Thanks alot for all of your help.