- Joined
- Dec 7, 2011
- Messages
- 1
- Reaction score
- 0
Trying to sort out a validation rule in MS Access. Anyone know it well enough?
TABLE
FIELD1 - Required Field. Text datatype, table input from Combo Box,
Value list for combo box of Yes; No; "" (null/blank)
FIELD2 - Text datatype. Want this required if Field1 is a "Yes,"
and consequently an error message if they change it, etc.
Anyone?
To put it in my non-valid language explanation...
"If TABLE.FIELD1="Yes" then TABLE.FIELD2=required" is what I want to do...
For English, these are two simple demographic table items...
"have you ever been convicted of a felony" (Always required)
and "if yes, please explain." (Required on Yes)
TABLE
FIELD1 - Required Field. Text datatype, table input from Combo Box,
Value list for combo box of Yes; No; "" (null/blank)
FIELD2 - Text datatype. Want this required if Field1 is a "Yes,"
and consequently an error message if they change it, etc.
Anyone?
To put it in my non-valid language explanation...
"If TABLE.FIELD1="Yes" then TABLE.FIELD2=required" is what I want to do...
For English, these are two simple demographic table items...
"have you ever been convicted of a felony" (Always required)
and "if yes, please explain." (Required on Yes)
Last edited: