Validation Assistance Needed, Please!

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I was wondering if there was anyway to set a validation
rule between two fields. Say i have a text field where i
enter a number value and a check box field set to yes/no
but the yes/no answer is dependant on whether i entered a
number in the first field. Can i put a validation rule on
the yes/no checkbox that will not allow the user to go to
the next record unless both the number field and the
checkbox are populated. Please Help!

Thanks Randy
 
Use the Validation Rule of the table, not that of the individual fields.

Open your table in design view.
Open the Properties box (Toobar icon).
Enter your rule into the Properties box.

A yes/no field cannot be Null, so I'm not sure what rule you want to insist
the check box is "populated".
 
Thanks for responding Allen, i feared that if i set the
rule it would require the checkbox to be populated. Is
there a way to set a warning message on the form so that
when you attempt to go to another record, it reminds the
user to confirm that the checkboxes are populated? please
advise

Thanks,
Randy
 
Randy, I don't understand what you mean by a check box being "populated".

Is it "populated" as long as it has a yes or no value? Or only a Yes value?
It is not possible in Access for a yes/no field to be unpopulated (i.e. for
it not to have a value).

If you want to insist the checkbox is checked if a number is entered (but it
may or may not be if the number is not entered), try this in the Validation
Rule of the *table*:
([MyNumber] Is Null) OR ([MyYesNo] = True)
 
Back
Top