G Guest Apr 27, 2007 #1 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
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
A Aaron Kempf Apr 27, 2007 #2 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
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
J John W. Vinson Apr 27, 2007 #3 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 Click to expand... 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]
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 Click to expand... 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]
G Guest Apr 28, 2007 #4 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 Click to expand... 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] Click to expand...
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 Click to expand... 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] Click to expand...
