Hi guys,
I would like to setup a validation rule for a database in microsoft
access that restricts data entry so that a certain field can only be
filled in if another field has a specific answer (that is selected via
a drop down list).
Example
Field1 - options are "In" or "Out"
Field2 - options are "Join" or "Not Joining"
I want a validation rule that only allows a user to select one of the
options in Field2 only when "In" is selected in Field1. If "Out" is
selected in Field1, then I don't want the user to be able enter data
into Field2 at all.
I'm not a computer illiterate but this is beyond me so f anyone could
help me out i would really appreciate it!!!!!!!!
Thanks! Sharsy
