Not allow enter fields if above condition not met

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have 2 check box fields; Passed Or Failed in my form
(Plus other); I also have a text box field name
UserInitial where I want to set a condition; I don't want
the user able to enter the UserInitial fields unless the
either one of the Passed or Failed checkbox is selected; A
message will warn if user attempt the enter initial without
select one of the check box first.

Thanks for any help.
 
1. Open your table in design view.

2. Open the Properties dialog (View menu).

3. Beside the Validation Rule in the Properties box (not the one in the
lower pane of talbe design, which applies to a field, not the table), enter:

(UserInitial Is Null) OR ((Passed Is Not Null) OR (Failed Is Not Null))

The rule is satisifed if UserInitial is blank.
If it's not, then the rule can be satisfied only if one of the other 2
fields is not blank.
 
Back
Top