Requiring one field contingent on data in another field

Dec 7, 2011
Reaction score
Trying to sort out a validation rule in MS Access. Anyone know it well enough?


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.


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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question