B
bsantona
How do I set a rule for a field in a form that is dependant on another field.
For example If field A = "YES" then Field B Must be >2
For example If field A = "YES" then Field B Must be >2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aaron Kempf
at the TABLE LEVEL
if you do it in a form; you'll have to rewrite it when you build a 2nd form
based on that table
if you do it in a form; you'll have to rewrite it when you build a 2nd form
based on that table
J
John W. Vinson
How do I set a rule for a field in a form that is dependant on another field.
For example If field A = "YES" then Field B Must be >2
Use a Table validation rule (in the Table properties in the design view). The
rule must cover both cases, e.g.
(FieldA = "Yes" AND [FieldB] > 2) OR [FieldB] <= 2
John W. Vinson [MVP]
B
bsantona
How about if the fields are on separate tables?
John W. Vinson said:How do I set a rule for a field in a form that is dependant on another field.
For example If field A = "YES" then Field B Must be >2
Use a Table validation rule (in the Table properties in the design view). The
rule must cover both cases, e.g.
(FieldA = "Yes" AND [FieldB] > 2) OR [FieldB] <= 2
John W. Vinson [MVP]